public bool SaveZone(mdlVendorEmployee ObjmdlVendorEmployee, DataTable dt, string SaveUpdate)
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
SqlTransaction transaction;
Con.Open();
transaction = Con.BeginTransaction();
bool Save = false;
try
{
SqlCommand cmd = new SqlCommand("stp_ERP_VendorEmployee_Crud", Con, transaction);
cmd.Parameters.Add("@pk_SPOId", SqlDbType.VarChar, 6).Value = ObjmdlVendorEmployee.pk_SPOId;
cmd.Parameters.Add("@SPOName", SqlDbType.VarChar, 50).Value = ObjmdlVendorEmployee.SPOName;
cmd.Parameters.Add("@CompanyId", SqlDbType.VarChar, 3).Value = ObjmdlVendorEmployee.CompanyId;
cmd.Parameters.Add("@GroupId", SqlDbType.VarChar, 6).Value = ObjmdlVendorEmployee.GroupId;
cmd.Parameters.Add("@ManagerId", SqlDbType.VarChar, 6).Value = ObjmdlVendorEmployee.ManagerId;
cmd.Parameters.Add("@Remarks", SqlDbType.VarChar, 100).Value = ObjmdlVendorEmployee.Remarks;
cmd.Parameters.Add("@chkMerck", SqlDbType.Bit).Value = Convert.ToBoolean(ObjmdlVendorEmployee.chkMerck);
cmd.Parameters.Add("@Discontinue", SqlDbType.Bit).Value = Convert.ToBoolean(ObjmdlVendorEmployee.Discontinue);
cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 16).Value = ObjmdlVendorEmployee.AddUser;
if (SaveUpdate == "Save")
{
cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 7).Value = "Save";
cmd.Parameters.Add("@Option", SqlDbType.VarChar, 20).Value = "ISPO";
}
if (SaveUpdate == "Update")
{
cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 7).Value = "Update";
cmd.Parameters.Add("@Option", SqlDbType.VarChar, 20).Value = "USPO";
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
Save = true;
if (SaveDetailZone(dt, transaction, ObjmdlVendorEmployee.pk_SPOId))
{
transaction.Commit();
Save = true;
}
else
{
Save = false;
}
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
}
catch (Exception ex)
{
try
{
transaction.Rollback();
}
catch (Exception e)
{
MessageBox.Show(e.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error);
Save = false;
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
}
Save = false;
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return Save;
}
public bool SaveUpdatePatient(mdlVendorEmployee ObjmdlVendorEmployee, string SaveUpdate)
{
bool Save = false;
try
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
SqlCommand cmd = new SqlCommand("stp_ERP_VendorEmployee_Crud", Con);
cmd.Parameters.Add("@pk_PatientId", SqlDbType.VarChar, 6).Value = ObjmdlVendorEmployee.pk_PatientId;
cmd.Parameters.Add("@PatientName", SqlDbType.VarChar, 30).Value = ObjmdlVendorEmployee.PatientName;
cmd.Parameters.Add("@DiscontinuedPatient", SqlDbType.Bit).Value = ObjmdlVendorEmployee.DiscontinuePatient;
cmd.Parameters.Add("@DoctorName", SqlDbType.VarChar, 30).Value = ObjmdlVendorEmployee.DoctorName;
cmd.Parameters.Add("@Address", SqlDbType.VarChar, 50).Value = ObjmdlVendorEmployee.Address;
cmd.Parameters.Add("@CoPatientId", SqlDbType.VarChar, 20).Value = ObjmdlVendorEmployee.CoPatientId;
cmd.Parameters.Add("@PhoneNo", SqlDbType.VarChar, 15).Value = ObjmdlVendorEmployee.PhoneNo;
cmd.Parameters.Add("@CellNo", SqlDbType.VarChar, 15).Value = ObjmdlVendorEmployee.CellNo;
cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 20).Value = ObjmdlVendorEmployee.AddUser;
if (SaveUpdate == "Save")
{
cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 7).Value = "Save";
cmd.Parameters.Add("@Option", SqlDbType.VarChar, 20).Value = "SPatientR";
}
if (SaveUpdate == "Update")
{
cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 7).Value = "Update";
cmd.Parameters.Add("@Option", SqlDbType.VarChar, 20).Value = "UPR";
}
Con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
Save = true;
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error);
Save = false;
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
}
return Save;
}
public bool SaveUpdatePatient(mdlVendorEmployee ObjmdlVendorEmployee, string SaveUpdate)
{
return ObjdalVendorEmployee.SaveUpdatePatient(ObjmdlVendorEmployee, SaveUpdate);
}
public bool SaveZones(mdlVendorEmployee ObjmdlVendorEmployee, DataTable dt, string SaveUpdate)
{
return ObjdalVendorEmployee.SaveZone(ObjmdlVendorEmployee, dt, SaveUpdate);
}
public bool SaveUpdateManager(mdlVendorEmployee ObjmdlVendorEmployee, string SaveUpdate)
{
return ObjdalVendorEmployee.SaveUpdateManager(ObjmdlVendorEmployee, SaveUpdate);
}