private Boolean FieldValidation()
{
IIQCareSystem IQCareSecurity = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security");
DateTime theCurrentDate = (DateTime)IQCareSecurity.SystemDate();
IQCareUtils theUtils = new IQCareUtils();
if (TxtFirstName.Text.Trim() == "")
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "First Name";
IQCareMsgBox.Show("BlankTextBox", theBuilder, this);
TxtFirstName.Focus();
return(false);
}
if (TxtLastName.Text.Trim() == "")
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "Last Name";
IQCareMsgBox.Show("BlankTextBox", theBuilder, this);
TxtLastName.Focus();
return(false);
}
if (TxtRegistrationDate.Text.Trim() == "")
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "Registration Date";
IQCareMsgBox.Show("BlankTextBox", theBuilder, this);
TxtRegistrationDate.Focus();
return(false);
}
DateTime theEnrolDate = Convert.ToDateTime(theUtils.MakeDate(TxtRegistrationDate.Text));
if (theEnrolDate > theCurrentDate)
{
IQCareMsgBox.Show("EnrolDate", this);
TxtRegistrationDate.Focus();
return(false);
}
if (DDGender.SelectedValue == "")
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "Sex";
IQCareMsgBox.Show("BlankTextBox", theBuilder, this);
DDGender.Focus();
return(false);
}
if (TxtDOB.Text.Trim() == "")
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "DOB";
IQCareMsgBox.Show("BlankTextBox", theBuilder, this);
TxtDOB.Focus();
return(false);
}
DateTime theDOBDate = Convert.ToDateTime(theUtils.MakeDate(TxtDOB.Text));
if (theDOBDate > theCurrentDate)
{
IQCareMsgBox.Show("DOBDate", this);
TxtDOB.Focus();
return(false);
}
if (theDOBDate > theEnrolDate)
{
IQCareMsgBox.Show("DOB_EnrolDate", this);
return(false);
}
/////17-09-09
//if (chkTransferIn.Checked == true && ddReferredFrom.SelectedIndex != 0)
//{
// // //MsgBuilder theBuilder = new MsgBuilder();
// // theBuilder.DataElements["Control"] = "RefFrom";
// //// IQCareMsgBox.Show("BlankDropDown", theBuilder, this);
// return false;
// }
////17-09-09
if (chkTransferIn.Checked == false && ddReferredFrom.SelectedIndex != 0)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "Either Tranfer in/Referred From";
IQCareMsgBox.Show("BlankDropDown", theBuilder, this);
return(false);
}
if (chkTransferIn.Checked == true && ddReferredFrom.SelectedIndex == 0)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "Either Tranfer in/Referred From";
IQCareMsgBox.Show("BlankDropDown", theBuilder, this);
return(false);
}
if (TxtANCNumber.Text == "" && TxtPMTCTNumber.Text == "" && TxtAdmissionNumber.Text == "" && TxtOutPatientNumber.Text == "")
{
IQCareMsgBox.Show("PMTCTEnrol_ANC", this);
return(false);
}
IPatientRegistration ValMgrPMTCT = (IPatientRegistration)ObjectFactory.CreateInstance(ObjFactoryParameter);
string msg = "";
if (TxtANCNumber.Text != "")
{
DataTable theDT = ValMgrPMTCT.Validate(TxtANCNumber.Text, "ANC");
if (theDT.Rows.Count > 0)
{
//if (Request.QueryString["Name"] == "Edit")
if (Convert.ToInt32(Session["PatientId"]) > 0) //i.e. update mode
{
if (theDT.Rows[0]["IDNumber"].ToString() != Convert.ToString(ViewState["ANC"]))
{
msg = "ANC" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this);
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = msg;
IQCareMsgBox.Show("#C1", theBuilder, this);
return(false);
}
}
else
{
msg = "ANC" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this);
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = msg;
IQCareMsgBox.Show("#C1", theBuilder, this);
return(false);
}
}
}
if (TxtPMTCTNumber.Text != "")
{
DataTable theDT = ValMgrPMTCT.Validate(TxtPMTCTNumber.Text, "PMTCT");
if (theDT.Rows.Count > 0)
{
//if (Request.QueryString["Name"] == "Edit")
//if (Request.QueryString["Name"] != "Add") //i.e. edit mode
if (Convert.ToInt32(Session["PatientId"]) > 0)
{
if (theDT.Rows[0]["IDNumber"].ToString() != ViewState["PMTCT"].ToString())
{
msg = "PMTCT" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this);
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = msg;
IQCareMsgBox.Show("#C1", theBuilder, this);
return(false);
}
}
else
{
msg = "PMTCT" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this);
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = msg;
IQCareMsgBox.Show("#C1", theBuilder, this);
return(false);
}
}
}
if (TxtAdmissionNumber.Text != "")
{
DataTable theDT = ValMgrPMTCT.Validate(TxtAdmissionNumber.Text, "Admission");
if (theDT.Rows.Count > 0)
{
//if (Request.QueryString["Name"] == "Edit")
//if (Request.QueryString["Name"] != "Add") //i.e. edit mode
if (Convert.ToInt32(Session["PatientId"]) > 0)
{
if (theDT.Rows[0]["IDNumber"].ToString() != ViewState["Admission"].ToString())
{
msg = "Admission" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this);
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = msg;
IQCareMsgBox.Show("#C1", theBuilder, this);
return(false);
}
}
else
{
msg = "Admission" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this);
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = msg;
IQCareMsgBox.Show("#C1", theBuilder, this);
return(false);
}
}
}
if (TxtOutPatientNumber.Text != "")
{
DataTable theDT = ValMgrPMTCT.Validate(TxtOutPatientNumber.Text, "Outpatient");
if (theDT.Rows.Count > 0)
{
//if (Request.QueryString["Name"] == "Edit")
//if (Request.QueryString["Name"] != "Add") //i.e. edit mode
if (Convert.ToInt32(Session["PatientId"]) > 0)
{
if (theDT.Rows[0]["IDNumber"].ToString() != ViewState["Outpatient"].ToString())
{
msg = "OutpatientNumber" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this);
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = msg;
IQCareMsgBox.Show("#C1", theBuilder, this);
return(false);
}
}
else
{
msg = "OutpatientNumber" + "' '" + IQCareMsgBox.GetMessage("PMTCTDuplicate", this);
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = msg;
IQCareMsgBox.Show("#C1", theBuilder, this);
return(false);
}
}
}
return(true);
}
private Boolean FieldValidation()
{
IIQCareSystem IQCareSecurity = (IIQCareSystem)ObjectFactory.CreateInstance("BusinessProcess.Security.BIQCareSystem, BusinessProcess.Security");
DateTime theCurrentDate = (DateTime)IQCareSecurity.SystemDate();
IQCareUtils theUtils = new IQCareUtils();
if (TxtFirstName.Text.Trim() == "")
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "First Name";
IQCareMsgBox.Show("BlankTextBox", theBuilder, this);
TxtFirstName.Focus();
return(false);
}
if (TxtLastName.Text.Trim() == "")
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "Last Name";
IQCareMsgBox.Show("BlankTextBox", theBuilder, this);
TxtLastName.Focus();
return(false);
}
if (TxtAdmissionNo.Text.Trim() == "")
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "Last Name";
IQCareMsgBox.Show("BlankTextBox", theBuilder, this);
return(false);
}
if (TxtRegistrationDate.Text.Trim() == "")
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "Registration Date";
IQCareMsgBox.Show("BlankTextBox", theBuilder, this);
TxtRegistrationDate.Focus();
return(false);
}
DateTime theEnrolDate = Convert.ToDateTime(theUtils.MakeDate(TxtRegistrationDate.Text));
if (theEnrolDate > theCurrentDate)
{
IQCareMsgBox.Show("EnrolDate", this);
TxtRegistrationDate.Focus();
return(false);
}
if (DDGender.SelectedValue == "")
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "Sex";
IQCareMsgBox.Show("BlankTextBox", theBuilder, this);
DDGender.Focus();
return(false);
}
if (TxtDOB.Text.Trim() == "")
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["Control"] = "DOB";
IQCareMsgBox.Show("BlankTextBox", theBuilder, this);
TxtDOB.Focus();
return(false);
}
DateTime theDOBDate = Convert.ToDateTime(theUtils.MakeDate(TxtDOB.Text));
if (theDOBDate > theCurrentDate)
{
IQCareMsgBox.Show("DOBDate", this);
TxtDOB.Focus();
return(false);
}
if (theDOBDate > theEnrolDate)
{
IQCareMsgBox.Show("DOB_EnrolDate", this);
return(false);
}
return(true);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (TxtUserId.Text.Length == 0)
{
// LblMsg.Text = "User Id Is Blank, Enter Valid User Id....";
TxtUserId.Focus();
return;
}
if (TxtUserName.Text.Length == 0)
{
// LblMsg.Text = "User Name Is Blank, Enter Valid User Name....";
TxtUserName.Focus();
return;
}
if (TxtLoginName.Text.Length == 0)
{
//LblMsg.Text = "Login Name Is Blank, Enter Valid Login Name....";
TxtLoginName.Focus();
return;
}
if (DDLUserGroup.SelectedValue == "0")
{
//LblMsg.Text = "Select User Group....";
DDLUserGroup.Focus();
return;
}
if (TxtDOB.Text.Length == 0)
{
//LblMsg.Text = "DOB Is Blank, Enter Valid Brith Date....";
TxtDOB.Focus();
return;
}
if (TxtEMailId.Text.Length == 0)
{
//LblMsg.Text = "EMail Id Is Blank, Enter Valid EMail Id....";
TxtEMailId.Focus();
return;
}
if (TxtMobNo.Text.Length == 0)
{
//LblMsg.Text = "Mob.No Is Blank, Enter Valid Mob.No....";
TxtMobNo.Focus();
return;
}
if (TxtPassword.Text.Length == 0)
{
//LblMsg.Text = "Password Is Blank, Enter Valid Password....";
TxtPassword.Focus();
return;
}
if (TxtQuestion.Text.Length == 0)
{
//LblMsg.Text = "Question Is Blank, Enter Valid Question....";
TxtQuestion.Focus();
return;
}
if (TxtAnswer.Text.Length == 0)
{
//LblMsg.Text = "Answer Is Blank, Enter Valid Answer....";
TxtAnswer.Focus();
return;
}
StrSql = new StringBuilder();
StrSql.Length = 0;
if (HidFldId.Value.Length == 0)
{
StrSql.AppendLine("Insert Into User_Mast (UId,UserName,LoginName");
StrSql.AppendLine(",UserGroup,Password ");
StrSql.AppendLine(",Gender,EMailId,DOB");
StrSql.AppendLine(",CountryId,StateId,CityId");
StrSql.AppendLine(",MobNo,Phone");
StrSql.AppendLine(",Question,Answer");
StrSql.AppendLine(",Activation");
StrSql.AppendLine(",Entry_Date,Entry_Time");
StrSql.AppendLine(",Entry_UID,UPDFLAG)");
StrSql.AppendLine("Values(@UserId,@UserName,@LoginName");
StrSql.AppendLine(",@UserGroup,@Password ");
StrSql.AppendLine(",@Gender,@EMailId,@DOB");
StrSql.AppendLine(",@CountryId,@StateId,@CityId");
StrSql.AppendLine(",@MobNo,@Phone");
StrSql.AppendLine(",@Question,@Answer");
StrSql.AppendLine(",@Activation");
StrSql.AppendLine(",GetDate(),Convert(VarChar,GetDate(),108)");
StrSql.AppendLine(",@Entry_UID,0)");
}
else
{
StrSql.AppendLine("Update User_Mast Set UId=@UserId,UserName=@UserName,LoginName=@LoginName");
StrSql.AppendLine(",UserGroup=@UserGroup,Password=@Password ");
StrSql.AppendLine(",Gender=@Gender,EMailId=@EMailId,DOB=@DOB");
StrSql.AppendLine(",CountryId=@CountryId,StateId=@StateId,CityId=@CityId");
StrSql.AppendLine(",MobNo=@MobNo,Phone=@Phone");
StrSql.AppendLine(",Question=@Question,Answer=@Answer");
StrSql.AppendLine(",Activation=@Activation");
StrSql.AppendLine(",MEntry_Date=GetDate(),MEntry_Time=Convert(Varchar,GetDate(),108)");
StrSql.AppendLine(",MEntry_UID=@Entry_UID,UPDFLAG=IsNull(UPDFlag,0)+1");
StrSql.AppendLine("Where Id=@Id");
}
Cmd = new SqlCommand(StrSql.ToString(), SqlFunc.gConn);
Cmd.Parameters.AddWithValue("@UserId", TxtUserId.Text.Trim());
Cmd.Parameters.AddWithValue("@UserName", TxtUserName.Text.Trim());
Cmd.Parameters.AddWithValue("@LoginName", TxtLoginName.Text.Trim());
Cmd.Parameters.AddWithValue("@UserGroup", DDLUserGroup.SelectedValue);
Cmd.Parameters.AddWithValue("@Password", Sec.Encrypt(TxtPassword.Text.Trim()));
Cmd.Parameters.AddWithValue("@Gender", rblGender.SelectedValue);
Cmd.Parameters.AddWithValue("@EMailId", TxtEMailId.Text.Trim());
Cmd.Parameters.AddWithValue("@DOB", ValueConvert.ConvertDate(TxtDOB.Text));
if (ddlCountry.SelectedValue != "0")
{
Cmd.Parameters.AddWithValue("@CountryId", ddlCountry.SelectedValue);
}
else
{
Cmd.Parameters.AddWithValue("@CountryId", DBNull.Value);
}
if (ddlState.SelectedValue != "0")
{
Cmd.Parameters.AddWithValue("@StateId", ddlState.SelectedValue);
}
else
{
Cmd.Parameters.AddWithValue("@StateId", DBNull.Value);
}
if (ddlCity.SelectedValue != "0")
{
Cmd.Parameters.AddWithValue("@CityId", ddlCity.SelectedValue);
}
else
{
Cmd.Parameters.AddWithValue("@CityId", DBNull.Value);
}
Cmd.Parameters.AddWithValue("@MobNo", TxtMobNo.Text.Trim());
Cmd.Parameters.AddWithValue("@Phone", TxtPhone.Text.Trim());
Cmd.Parameters.AddWithValue("@Question", TxtQuestion.Text.Trim());
Cmd.Parameters.AddWithValue("@Answer", TxtAnswer.Text.Trim());
Cmd.Parameters.AddWithValue("@Activation", 0);
Cmd.Parameters.AddWithValue("@Entry_UID", HidFldUID.Value.ToString());
if (HidFldId.Value.Length == 0)
{
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "User added successfully";
}
else
{
Cmd.Parameters.AddWithValue("@ID", HidFldId.Value.ToString());
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "User updated successfully";
}
FillGrid();
ClearAll();
MyMenu.Items[0].Selected = true;
MyMenu.Items[0].ImageUrl = "~/Images/ViewEnable.jpg";
MyMultiView.ActiveViewIndex = 0;
MyMenu.Items[1].ImageUrl = "~/Images/NewOrEditDisable.jpg";
}
catch (Exception ex)
{
Response.Write(ex);
}
}