void insertflats()
{
try
{
for (int i = 1; i <= Convert.ToInt32(txtflats.Value); i++)
{
tblavailableblock avlblock = new tblavailableblock();
avlblock.BlockId = Convert.ToInt32(ddlflats.SelectedValue);
avlblock.BlockNo = i;
int ISSuccessfull = InsertionLayer.insertNoOFflats(avlblock);
if (ISSuccessfull == 1)
{
lblmsg.Text = "You Have Successfully Added The Flat In " + ddlflats.SelectedItem.Text;
BindFlatsList();
}
else
{
lblmsg.Text = "Technical error Please Try After Sometime";
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateFlatIdStatus(int FlatId)
{
tblavailableblock k = con.da.tblavailableblocks.Where(x => x.Id == FlatId).FirstOrDefault();
if (k != null)
{
k.IsBooked = true;
}
con.da.SubmitChanges();
}
/// <summary>
/// code to insert no. of flats
/// </summary>
/// <param name="avlblock"></param>
/// <returns></returns>
public static int insertNoOFflats(tblavailableblock avlblock)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
avlblock.Crdt = DateTime.Now;
avlblock.Updt = DateTime.Now;
avlblock.IsActive = true;
avlblock.IsBooked = false;
objdata.tblavailableblocks.InsertOnSubmit(avlblock);
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// code to delete flats...
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public static int DeleteFlats(int ids)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
tblavailableblock avlblocks = objdata.tblavailableblocks.Where(x => x.Id == ids).FirstOrDefault();
if (avlblocks != null)
{
avlblocks.IsActive = false;
}
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// code to edit flats name
/// </summary>
/// <param name="ids"></param>
/// <param name="flatname"></param>
/// <returns></returns>
public static int EditFlatsName(int ids, int flatname, int BlockId)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
tblavailableblock avlblock = objdata.tblavailableblocks.Where(x => x.Id == ids).FirstOrDefault();
if (avlblock != null)
{
avlblock.BlockNo = flatname;
avlblock.BlockId = BlockId;
}
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
