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; } }