Sunday, December 30, 2012

@Scripts.Render("~/bundles/jqueryval")


if you are using kendo UI web for asp.net MVC and you are getting the error when you are click on create new.






just hide/remove the code from create & Edit razor view of your controller


 @section Scripts {  
   @Scripts.Render("~/bundles/jqueryval")  
 }  


*Now This problem is resolve in VS 2013

Wednesday, December 26, 2012

silverlight hyperlink button image in datagrid column

In tool hyperlink image button in silverlight datagrid we can set property, command like other control.
the binding of the datagrid column is:


  <sdk:DataGridTemplateColumn Header="Buyer Comments" Width="2*">  
             <sdk:DataGridTemplateColumn.CellTemplate>  
               <DataTemplate>  
                 <StackPanel Orientation="Horizontal">  
                   <HyperlinkButton Content="" Width="30" Command="{Binding Source={StaticResource srConfirm}, Path=ShowComments}"   
                            CommandParameter="{Binding}" ToolTipService.ToolTip="{Binding Path=Comments}">  
                     <HyperlinkButton.Background>  
                       <ImageBrush ImageSource="/images/Icons/add.png" Stretch="Uniform" />  
                     </HyperlinkButton.Background>  
                   </HyperlinkButton>  
                 </StackPanel>  
               </DataTemplate>  
             </sdk:DataGridTemplateColumn.CellTemplate>  
           </sdk:DataGridTemplateColumn>  

here srConfirm is the Viewmodel of the window which i defined in cs.

     private VMEditReceiveBuyerComment _dataContext = null;  
     public EditBuyerCommentReceival()  
     {  
       _dataContext = new VMEditReceiveBuyerComment();  
                this.Resources.Add("srConfirm", _dataContext);  
       InitializeComponent();  
       this.DataContext = _dataContext;  
     }  

Sunday, December 23, 2012

SQL auto generate last column id without auto increment

If we want to get a table autogenerate column id, without auto increment column. we can do it easily.
we can also made it globally for all table. We can create a table name paramaterize store procedure that
will give us table last column ID without using auto increment column.

 CREATE PROCEDURE [dbo].[spSET_GetDB_TablePKID]  
      @tableName [varchar](100),  
      @locationId [int]  
 AS  
 BEGIN  
 declare @newID varchar(20)  
 declare @dbID varchar(20)  
 declare @generateID bigint  
 declare @ReturnValue varchar(100)  
  if exists(select * from DB_TablePKID where LocationID=@locationId and TableName=@tableName)  
   begin  
   --table name exists  
   set @ReturnValue= (select MaxID+1 from DB_TablePKID where LocationID=@locationId and TableName=@tableName)  
   end  
  else --table name is not exists.  
   begin  
   -- generate new first ID for the supplied table  
   select @dbID= DBid from DB where DBLocationID=@locationId  
   set @newID=@dbID+'00000000000001'  
   set @generateID=convert(bigint,@newID)  
   set @ReturnValue=@generateID  
   end   
   select @ReturnValue  
 end  

declar the store procedure in C#

 public long GetTablekeyID(string tableName, int locationId)  
     {  
       long id = 0;  
       // id = _db.spSET_GetDB_TablePKID(tableName, locationId);  
       System.Data.Objects.ObjectResult<string> sid = this.DataContext.spSET_GetDB_TablePKID(tableName, locationId);  
       foreach (string aa in sid)  
       {  
         id = long.Parse(aa.ToString());  
       }  
       return id;  
     }  

Now call from anywhere with your any table name. it will return last id of your table. here locationID is optional.

Tuesday, December 11, 2012

C# globally check List instance's item count

 We can check an instance of a list count() globally


 public class CheckListCount  
   {  
     public bool IsOneItemEntry(IEnumerable<dynamic> objEntity)  
     {  
             String ErrorMessage="";  
       bool IsValid = true;  
       if (objEntity.Count() == 0)  
       {  
         IsValid = false;  
         ErrorMessage = "At least one item must be available.";  
       }  
       return IsValid;  
     }  
   }  

Now create instance in any class &  check any list's instance Count();

  private CheckListCount _CheckList = new CheckListCount();  
       List<CommentReceipt> CommentReceiveItem = new List<CommentReceipt>();  
         foreach (LAB_LDCommentReceipt receipt in ViewData.LdCommentReceiveList)  
         {  
           if (receipt.AppStatusID>0)  
           {  
             CommentReceiveItem.Add(receipt);  
           }  
         }  
          if (_CheckList.IsOneItemEntry(CommentReceiveItem))  
          {  
           // do something  
          }  

Monday, December 10, 2012

Date range query in Entity framework



Entity Framework Date rang query is not same as like LINQ.
You can try like this


 var events = this.coreDomainContext.Events.Where(  
   e => EntityFunctions.TruncateTime(e.EventDate.Value) >= DateTime.Today  
    && EntityFunctions.TruncateTime(e.EventDate.Value) <= EntityFunctions.TruncateTime(endPeriod))  
   .OrderByDescending(e => e.EventDate)  
   .ToList();  

For details you can See

Tuesday, December 4, 2012

silverlight ria services association class relationship

If you have association relationship in your class. then normally you will not get the associated list data using Silverlight ria service. how to solve it..? please see this

MSDN Silverlight Ria Service Fourm

SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...