protected void BtnUpdate_Click(object sender, EventArgs e)
{
int i = Convert.ToInt32(hiddenbox.Value);
if (i == 0)
{
int UpdateRow = 0;
try
{
if (ViewState["EditID"] != null)
{
Entity_FlatType.FlatTypeId = Convert.ToInt32(ViewState["EditID"]);
}
Entity_FlatType.FlatType = txtFlatType.Text.Trim();
Entity_FlatType.UserId = Convert.ToInt32(Session["UserId"]);
Entity_FlatType.LoginDate = DateTime.Now;
UpdateRow = Obj_FlatType.UpdateFlatType(ref Entity_FlatType, out StrError);
if (UpdateRow != 0)
{
Obj_Comm.ShowPopUpMsg("Record Updated Successfully", this.Page);
MakeEmptyForm();
Entity_FlatType = null;
Obj_Comm = null;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
public int UpdateFlatType(ref FlatTypeMaster Entity_FlatType, out string StrError)
{
int iInsert = 0;
StrError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(FlatTypeMaster._Action, SqlDbType.BigInt);
SqlParameter pFlatTypeId = new SqlParameter(FlatTypeMaster._FlatTypeId, SqlDbType.BigInt);
SqlParameter pFlatType = new SqlParameter(FlatTypeMaster._FlatType, SqlDbType.NVarChar);
SqlParameter pProjectTypeID = new SqlParameter(FlatTypeMaster._ProjectTypeID, SqlDbType.BigInt);
SqlParameter pCreatedBy = new SqlParameter(FlatTypeMaster._UserId, SqlDbType.BigInt);
SqlParameter pCreatedDate = new SqlParameter(FlatTypeMaster._LoginDate, SqlDbType.DateTime);
pAction.Value = 2;
pFlatTypeId.Value = Entity_FlatType.FlatTypeId;
pFlatType.Value = Entity_FlatType.FlatType;
pProjectTypeID.Value = Entity_FlatType.ProjectTypeID;
pCreatedBy.Value = Entity_FlatType.UserId;
pCreatedDate.Value = Entity_FlatType.LoginDate;
SqlParameter[] param = new SqlParameter[] { pAction, pFlatTypeId, pFlatType, pProjectTypeID, pCreatedBy, pCreatedDate };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, FlatTypeMaster.SP_FlatTypeMaster, param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
StrError = ex.Message;
}
finally
{
Close();
}
return(iInsert);
}
public int DeleteFlatType(ref FlatTypeMaster Entity_FlatType, out string StrError)
{
int iDelete = 0;
StrError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(FlatTypeMaster._Action, SqlDbType.BigInt);
SqlParameter pFlatTypeId = new SqlParameter(FlatTypeMaster._FlatTypeId, SqlDbType.BigInt);
SqlParameter pDeletedBy = new SqlParameter(FlatTypeMaster._UserId, SqlDbType.BigInt);
SqlParameter pDeletedDate = new SqlParameter(FlatTypeMaster._LoginDate, SqlDbType.DateTime);
pAction.Value = 3;
pFlatTypeId.Value = Entity_FlatType.FlatTypeId;
pDeletedBy.Value = Entity_FlatType.UserId;
pDeletedDate.Value = Entity_FlatType.LoginDate;
// pIsDeleted.Value = Entity_Country.IsDeleted;
SqlParameter[] param = new SqlParameter[] { pAction, pFlatTypeId, pDeletedBy, pDeletedDate };
Open(CONNECTION_STRING);
BeginTransaction();
iDelete = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, FlatTypeMaster.SP_FlatTypeMaster, param);
if (iDelete > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
StrError = ex.Message;
}
finally
{
Close();
}
return(iDelete);
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
int i = Convert.ToInt32(hiddenbox.Value);
if (i == 0)
{
try
{
int DeleteId = 0;
if (ViewState["EditID"] != null)
{
if (long.Parse(hdnFldUsedCnt.Value.ToString()) > 0)
{
Obj_Comm.ShowPopUpMsg("Unit type is in use. Cannot Delete Record...", this.Page);
return;
}
DeleteId = Convert.ToInt32(ViewState["EditID"]);
}
if (DeleteId != 0)
{
Entity_FlatType.FlatTypeId = DeleteId;
Entity_FlatType.UserId = Convert.ToInt32(Session["UserId"]);
Entity_FlatType.LoginDate = DateTime.Now;
int iDelete = Obj_FlatType.DeleteFlatType(ref Entity_FlatType, out StrError);
if (iDelete != 0)
{
Obj_Comm.ShowPopUpMsg("Record Deleted Successfully..!", this.Page);
MakeEmptyForm();
}
}
Entity_FlatType = null;
Obj_Comm = null;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
int InsertRow = 0;
try
{
DS = Obj_FlatType.ChkDuplicate(txtFlatType.Text.Trim().ToUpper(), out StrError);
if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
Obj_Comm.ShowPopUpMsg("This Unit Type Already Exist For ", this.Page);
txtFlatType.Focus();
}
else
{
Entity_FlatType.FlatType = txtFlatType.Text.Trim();
Entity_FlatType.UserId = Convert.ToInt32(Session["UserId"]);
Entity_FlatType.LoginDate = DateTime.Now;
InsertRow = Obj_FlatType.InsertFlatType(ref Entity_FlatType, out StrError);
if (InsertRow > 0)
{
Obj_Comm.ShowPopUpMsg("Record Saved Successfully", this.Page);
MakeEmptyForm();
Entity_FlatType = null;
Obj_Comm = null;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
