protected void btnSave_Click(object sender, EventArgs e)
{
try
{
var objSerialNoBo = new SerialNoBo();
var objSerialNoBl = new SerialNoBl();
int intId = 0;
objSerialNoBo.TrustMID = Convert.ToInt32(ddlTrust.SelectedValue);
objSerialNoBo.SchoolMID = ddlSchool.SelectedValue != "" ? Convert.ToInt32(ddlSchool.SelectedValue) : 0;
objSerialNoBo.Year = Convert.ToInt32(ddlYear.SelectedValue);
objSerialNoBo.EntryType = ddlType.SelectedValue;
objSerialNoBo.StartNo = Convert.ToInt32(txtStartNo.Text);
objSerialNoBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.USERID]);
objSerialNoBo.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(CultureInfo.InvariantCulture);
objSerialNoBo.IsDeleted = 0;
objSerialNoBo.LastModifideDate = DateTime.UtcNow.AddHours(5.5).ToString(CultureInfo.InvariantCulture);
objSerialNoBo.LastModifideUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
switch (ViewState["Mode"].ToString())
{
case "Save":
intId = -1;
break;
case "Edit":
intId = Convert.ToInt32(ViewState["Id"].ToString());
break;
}
var objResultValidate = objSerialNoBl.SerialNo_ValidateName(intId, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ddlYear.SelectedValue), ddlType.SelectedValue);
if (objResultValidate != null)
{
var dtResultValidate = objResultValidate.resultDT;
if (dtResultValidate.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('This record already exists.');</script>");
}
else
{
if (ViewState["Mode"].ToString() == "Save")
{
var objResult = objSerialNoBl.SerialNo_Insert(objSerialNoBo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
}
}
else
{
objSerialNoBo.Id = Convert.ToInt32(ViewState["Id"]);
var objResult = objSerialNoBl.SerialNo_Update(objSerialNoBo);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", objResult.status == ApplicationResult.CommonStatusType.SUCCESS
? "<script>alert('Record Updated Successfully.');</script>"
: "<script>alert('You can not changed the record. It is already in use.');</script>");
}
Clear();
BindGrid();
PanelVisibility(1);
}
}
}
catch (Exception ex)
{
Logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
/// <summary>
/// To Update details of SerialNo in tbl_SerialNoInit_M table
/// Created By : Viral, 10/29/2014
/// Modified By :
/// </summary>
/// <param name="objSerialNoBo"></param>
/// <returns></returns>
public ApplicationResult SerialNo_Update(SerialNoBo objSerialNoBo)
{
PSqlParameter = new SqlParameter[11];
PSqlParameter[0] = new SqlParameter("@Id", SqlDbType.Int)
{
Direction = ParameterDirection.Input,
Value = objSerialNoBo.Id
};
PSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int)
{
Direction = ParameterDirection.Input,
Value = objSerialNoBo.TrustMID
};
PSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int)
{
Direction = ParameterDirection.Input,
Value = objSerialNoBo.SchoolMID
};
PSqlParameter[3] = new SqlParameter("@StartNo", SqlDbType.Int)
{
Direction = ParameterDirection.Input,
Value = objSerialNoBo.StartNo
};
PSqlParameter[4] = new SqlParameter("@Year", SqlDbType.Int)
{
Direction = ParameterDirection.Input,
Value = objSerialNoBo.Year
};
PSqlParameter[5] = new SqlParameter("@EntryType", SqlDbType.NVarChar)
{
Direction = ParameterDirection.Input,
Value = objSerialNoBo.EntryType
};
PSqlParameter[6] = new SqlParameter("@CreatedBy", SqlDbType.Int)
{
Direction = ParameterDirection.Input,
Value = objSerialNoBo.CreatedBy
};
PSqlParameter[7] = new SqlParameter("@CreatedDate", SqlDbType.NVarChar)
{
Direction = ParameterDirection.Input,
Value = objSerialNoBo.CreatedDate
};
PSqlParameter[8] = new SqlParameter("@IsDeleted", SqlDbType.Int)
{
Direction = ParameterDirection.Input,
Value = objSerialNoBo.IsDeleted
};
PSqlParameter[9] = new SqlParameter("@LastModifideDate", SqlDbType.NVarChar)
{
Direction = ParameterDirection.Input,
Value = objSerialNoBo.LastModifideDate
};
PSqlParameter[10] = new SqlParameter("@LastModifideUserID", SqlDbType.Int)
{
Direction = ParameterDirection.Input,
Value = objSerialNoBo.LastModifideUserID
};
SSql = "usp_tbl_SerialNoInit_M_Update";
var iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, SSql, PSqlParameter);
if (iResult > 0)
{
var objResults = new ApplicationResult {
status = ApplicationResult.CommonStatusType.SUCCESS
};
return(objResults);
}
else
{
var objResults = new ApplicationResult {
status = ApplicationResult.CommonStatusType.FAILURE
};
return(objResults);
}
}
