/// <summary>
/// code for insertion of blocks
/// </summary>
/// <param name="block"></param>
/// <returns></returns>
public static int insertblocks(tblblockcategory block)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
block.Crdt = DateTime.Now;
block.Updt = DateTime.Now;
block.IsActive = true;
objdata.tblblockcategories.InsertOnSubmit(block);
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// code to edit block name
/// </summary>
/// <param name="ids"></param>
/// <param name="blockname"></param>
/// <returns></returns>
public static int EditBlockName(int ids, string blockname)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
tblblockcategory block = objdata.tblblockcategories.Where(x => x.Id == ids).FirstOrDefault();
if (block != null)
{
block.BlockName = blockname.ToString();
}
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// code to delete blocks...
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public static int DeleteBlock(int ids)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
tblblockcategory blockcatgry = objdata.tblblockcategories.Where(x => x.Id == ids).FirstOrDefault();
if (blockcatgry != null)
{
blockcatgry.IsActive = false;
}
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
