protected void BtnDelete_Click(object sender, EventArgs e)
{
try
{
int DeleteId = 0;
if (ViewState["EditID"] != null)
{
DeleteId = Convert.ToInt32(ViewState["EditID"]);
}
if (DeleteId != 0)
{
Entity_PR.PropertySubTypeId = DeleteId;
Entity_PR.LoginId = Convert.ToInt32(Session["UserID"]);
Entity_PR.LoginDate = DateTime.Now;
int iDelete = Obj_PR.DeleteRecord(ref Entity_PR, out StrError);
if (iDelete != 0)
{
obj_Comm.ShowPopUpMsg("Record Deleted Successfully..!", this.Page);
MakeEmptyForm();
}
}
Entity_PR = null;
obj_Comm = null;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public int InsertRecord(ref PropertySubTypeMaster Entity_call, out string strError)
{
int iInsert = 0;
strError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(PropertySubTypeMaster._Action, SqlDbType.BigInt);
SqlParameter pPropertySubTypeDesc = new SqlParameter(PropertySubTypeMaster._PropertySubTypeDesc, SqlDbType.NVarChar);
SqlParameter pProjectTypeId = new SqlParameter(PropertySubTypeMaster._PropertyTypeId, SqlDbType.BigInt);
SqlParameter pCreatedBy = new SqlParameter(PropertySubTypeMaster._LoginId, SqlDbType.BigInt);
SqlParameter PCreatedDate = new SqlParameter(PropertySubTypeMaster._LoginDate, SqlDbType.DateTime);
pAction.Value = 1;
pPropertySubTypeDesc.Value = Entity_call.PropertySubTypeDesc;
pProjectTypeId.Value = Entity_call.PropertyTypeId;
pCreatedBy.Value = Entity_call.LoginId;
PCreatedDate.Value = Entity_call.LoginDate;
SqlParameter[] param = new SqlParameter[] { pAction, pPropertySubTypeDesc, pProjectTypeId, pCreatedBy, PCreatedDate };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteScalar(_Connection, _Transaction, CommandType.StoredProcedure, PropertySubTypeMaster.SP_PropertySubTypeMaster, param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
strError = ex.Message;
}
finally
{
Close();
}
return(iInsert);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
int InsertRow = 0;
try
{
DS = Obj_PR.ChkDuplicate(TxtPropertySubType.Text.Trim(), out StrError);
if (DS.Tables[0].Rows.Count > 0)
{
obj_Comm.ShowPopUpMsg("PropertySubType Name Already Exist..!", this.Page);
TxtPropertySubType.Focus();
}
else
{
Entity_PR.PropertySubTypeDesc = TxtPropertySubType.Text.Trim();
if (Convert.ToInt32(ddlPropertyType.SelectedValue) > 0)
{
Entity_PR.PropertyTypeId = Convert.ToInt32(ddlPropertyType.SelectedValue);
}
else
{
obj_Comm.ShowPopUpMsg("Select PropertyType First..!", this.Page);
ddlPropertyType.Focus();
return;
}
Entity_PR.LoginId = Convert.ToInt32(Session["UserId"]);
Entity_PR.LoginDate = DateTime.Now;
InsertRow = Obj_PR.InsertRecord(ref Entity_PR, out StrError);
if (InsertRow != 0)
{
obj_Comm.ShowPopUpMsg("Record Saved Successfully", this.Page);
MakeEmptyForm();
Entity_PR = null;
obj_Comm = null;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public int DeleteRecord(ref PropertySubTypeMaster EntityCall, out string StrError)
{
int iDelete = 0;
StrError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(PropertySubTypeMaster._Action, SqlDbType.BigInt);
SqlParameter PStateId = new SqlParameter(PropertySubTypeMaster._PropertySubTypeId, SqlDbType.BigInt);
SqlParameter pDeletedBy = new SqlParameter(PropertySubTypeMaster._LoginId, SqlDbType.BigInt);
SqlParameter pDeletedDate = new SqlParameter(PropertySubTypeMaster._LoginDate, SqlDbType.DateTime);
pAction.Value = 3;
PStateId.Value = EntityCall.PropertySubTypeId;
pDeletedBy.Value = EntityCall.LoginId;
pDeletedDate.Value = EntityCall.LoginDate;
SqlParameter[] param = new SqlParameter[] { pAction, PStateId, pDeletedBy, pDeletedDate };
Open(CONNECTION_STRING);
BeginTransaction();
iDelete = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, PropertySubTypeMaster.SP_PropertySubTypeMaster, param);
if (iDelete > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
StrError = ex.Message;
}
finally
{
Close();
}
return(iDelete);
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
int UpdateRow = 0;
try
{
if (ViewState["EditID"] != null)
{
Entity_PR.PropertySubTypeId = Convert.ToInt32(ViewState["EditID"]);
}
Entity_PR.PropertySubTypeDesc = TxtPropertySubType.Text.Trim();
if (Convert.ToInt32(ddlPropertyType.SelectedValue) > 0)
{
Entity_PR.PropertyTypeId = Convert.ToInt32(ddlPropertyType.SelectedValue);
}
else
{
obj_Comm.ShowPopUpMsg("Select ProprtyType First", this.Page);
ddlPropertyType.Focus();
return;
}
Entity_PR.LoginId = Convert.ToInt32(Session["UserId"]);
Entity_PR.LoginDate = DateTime.Now;
UpdateRow = Obj_PR.UpdateRecord(ref Entity_PR, out StrError);
if (UpdateRow != 0)
{
obj_Comm.ShowPopUpMsg("Record Updated Successfully", this.Page);
MakeEmptyForm();
Entity_PR = null;
obj_Comm = null;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
