/// <summary>
/// Get All Reactivation Info
/// </summary>
/// <returns></returns>
///
public List <clsReactivation> GetAllReactivationList(clsDocumentFilter clsdoc)
{
List <clsReactivation> lst = new List <clsReactivation>();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetAllReactivations"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@RegistrationNo", clsdoc.strRegistrationNo);
cmd.Parameters.AddWithValue("@ProjectID", clsdoc.strProjectID);
cmd.Parameters.AddWithValue("@ClientID", clsdoc.strClientID);
cmd.Parameters.AddWithValue("@StartDate", clsdoc.dateStartDate);
cmd.Parameters.AddWithValue("@EndDate", clsdoc.dateEndDate);
cmd.Parameters.AddWithValue("@ApprovalStatusCode", clsdoc.intApprovalStatusCode);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var info = new clsReactivation();
info.RegistrationOrBookingNo = reader["RegistrationNo"].ToString();
info.ClientID = reader["ClientID"].ToString();
info.ReActivationDate = Convert.ToDateTime(reader["ReActivationDate"].ToString());
info.Approved = Convert.ToBoolean(reader["Approve"].ToString());
info.Remarks = reader["Remarks"].ToString();
info.strProjectid = reader["ProjectID"].ToString();
info.ApprovalStatusCode = Convert.ToInt32(reader["ApprovalStatusCode"].ToString());
info.ApprovalStatusDescription = reader["ApprovalStatusDescription"].ToString();
info.ApprovalActionUser = reader["ApprovalActionUser"].ToString();
info.ApprovalActionDate = Convert.ToDateTime(reader["ApprovalActionDate"]);
info.CreatedBy = reader["CreatedBy"].ToString();
info.CreationDate = Convert.ToDateTime(reader["CreationDate"].ToString());
info.LastUpdateUser = reader["LastUpdateUser"].ToString();
info.LastUpdateDate = Convert.ToDateTime(reader["LastUpdateDate"]);
info.intPreviousStatusCode = Convert.ToInt32(reader["PreviousStatusCode"].ToString());
info.StatusDescription = reader["StatusDescription"].ToString();
info.id = Convert.ToInt32(reader["id"].ToString());
lst.Add(info);
}
conn.Close();
}
}
return(lst);
}
/// <summary>
/// Add Reactivation Info
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool AddReActivation(clsReactivation info)
{
int st = 0;
try
{
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
{
using (SqlCommand cmd = new SqlCommand("TMR_USP_AddReActivation"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@id", info.id);
cmd.Parameters.AddWithValue("@RegistrationNo", info.RegistrationOrBookingNo);
cmd.Parameters.AddWithValue("@ClientID", info.ClientID);
cmd.Parameters.AddWithValue("@ProjectID", info.strProjectid);
cmd.Parameters.AddWithValue("@ReactivationDate", info.ReActivationDate);
cmd.Parameters.AddWithValue("@Approve", info.Approved);
cmd.Parameters.AddWithValue("@Remarks", info.Remarks);
cmd.Parameters.AddWithValue("@ApprovalStatusCode", info.ApprovalStatusCode);
cmd.Parameters.AddWithValue("@ApprovalActionUser", info.ApprovalActionUser);
cmd.Parameters.AddWithValue("@ApprovalActionDate", info.ApprovalActionDate);
cmd.Parameters.AddWithValue("@CreatedBy", info.CreatedBy);
cmd.Parameters.AddWithValue("@CreationDate", info.CreationDate);
cmd.Parameters.AddWithValue("@LastUpdateUser", info.LastUpdateUser);
cmd.Parameters.AddWithValue("@LastUpdateDate", info.LastUpdateDate);
cmd.Parameters.AddWithValue("@PreviousStatusCode", info.intPreviousStatusCode);
st = cmd.ExecuteNonQuery();
}
}
conn.Close();
}
}
catch (Exception ex) { }
if (st > 0)
{
return(true);
}
else
{
return(false);
}
}
private void frmReactivation_Load(object sender, EventArgs e)
{
SetUserSecurity();
cmbApprovalStatus.Text = "Not Saved";
if (id != 0)
{
txtRegistrationNo.Enabled = false;
clsReac = da.GetReactivationById(id);
btnSelect.Enabled = false;
txtRegistrationNo.Text = clsReac.RegistrationOrBookingNo;
txtClientID.Text = clsReac.ClientID;
dTReactivationDate.Value = clsReac.ReActivationDate;
txtRemarks.Text = clsReac.Remarks;
txtProject.Text = clsReac.strProjectid;
chkBoxApproved.Checked = clsReac.Approved;
EntryApproved = (ApprovalStatus)clsReac.ApprovalStatusCode;
if ((ApprovalStatus)clsReac.ApprovalStatusCode == ApprovalStatus.Pending)
{
cmbApprovalStatus.Text = "Pending";
}
else if ((ApprovalStatus)clsReac.ApprovalStatusCode == ApprovalStatus.Approved)
{
cmbApprovalStatus.Text = "Approved";
}
else if ((ApprovalStatus)clsReac.ApprovalStatusCode == ApprovalStatus.Rejected)
{
cmbApprovalStatus.Text = "Rejected";
}
var v = da.GetMemberRegistrationInfoByMembershipAndCNIC(clsReac.RegistrationOrBookingNo, clsReac.ClientID);
txtSizeCode.Text = v.Plan;
txtClientName.Text = v.Name;
txtBookingDate.Text = v.Booking.ToString("dd/MM/yyy");
txtBookingPrice.Text = v.BookingPrice.ToString("N2");
txtNetRetailPrice.Text = v.NetOrRetailPrice.ToString("N2");
txtRebatAmt.Text = v.RebatAmt.ToString("N2");
txtTotalPrice.Text = v.TotalPrice.ToString("N2");
LoadMemberImage();
}
}
//public clsReactivation GetReactivationById(int id)
//{
// clsReactivation obj = new clsReactivation();
// using (SqlConnection conn = new SqlConnection(strConn))
// {
// conn.Open();
// using (SqlCommand cmd = new SqlCommand("TMR_USP_GetReactivationByID"))
// {
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Connection = conn;
// cmd.Parameters.AddWithValue("@id", id);
// //cmd.Parameters.AddWithValue("@SizeCode", strSizeCode);
// SqlDataReader reader = cmd.ExecuteReader();
// while (reader.Read())
// {
// obj.RegistrationOrBookingNo = reader["RegistrationNo"].ToString();
// obj.ClientID = reader["ClientID"].ToString();
// obj.Remarks = reader["Remarks"].ToString();
// obj.ReActivationDate = Convert.ToDateTime(reader["ReActivationDate"]);
// obj.Approved = Convert.ToBoolean(reader["Approve"]);
// obj.id = Convert.ToInt32(reader["id"]);
// }
// conn.Close();
// }
// }
// return obj;
//}
#endregion
public clsReactivation GetReactivationById(int id)
{
clsReactivation info = new clsReactivation();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetReactivationByID"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@id", id);
//cmd.Parameters.AddWithValue("@SizeCode", strSizeCode);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
info.RegistrationOrBookingNo = reader["RegistrationNo"].ToString();
info.ClientID = reader["ClientID"].ToString();
info.strProjectid = reader["ProjectID"].ToString();
info.ReActivationDate = Convert.ToDateTime(reader["ReActivationDate"]);
info.Approved = Convert.ToBoolean(reader["Approve"].ToString());
info.Remarks = reader["Remarks"].ToString();
info.intPreviousStatusCode = Convert.ToInt32(reader["PreviousStatusCode"]);
info.ApprovalStatusCode = Convert.ToInt32(reader["ApprovalStatusCode"].ToString());
info.ApprovalStatusDescription = reader["ApprovalStatusDescription"].ToString();
info.ApprovalActionUser = reader["ApprovalActionUser"].ToString();
info.ApprovalActionDate = Convert.ToDateTime(reader["ApprovalActionDate"].ToString());
info.CreatedBy = reader["CreatedBy"].ToString();
info.CreationDate = Convert.ToDateTime(reader["CreationDate"].ToString());
info.LastUpdateUser = reader["LastUpdateUser"].ToString();
info.LastUpdateDate = Convert.ToDateTime(reader["LastUpdateDate"].ToString());
info.id = Convert.ToInt32(reader["id"]);
}
conn.Close();
}
}
return(info);
}
private void SaveCancellation(ApprovalStatus approvalStatus)
{
if (EntryApproved != ApprovalStatus.Pending)
{
MessageBox.Show("This entry has already been Approved/Rejected");
return;
}
if (id == 0 && approvalStatus != ApprovalStatus.Pending)
{
MessageBox.Show("This entry needs to be saved first before approval process.");
return;
}
var clsReac = new clsReactivation();
clsReac.id = id;
clsReac.RegistrationOrBookingNo = txtRegistrationNo.Text;
clsReac.ClientID = txtClientID.Text;
clsReac.ReActivationDate = dTReactivationDate.Value;
clsReac.Remarks = txtRemarks.Text.Trim();
clsReac.Approved = chkBoxApproved.Checked;
clsReac.strProjectid = txtProject.Text;
if (id == 0)
{
clsReac.CreatedBy = Dynamics.Globals.UserId;
clsReac.CreationDate = DateTime.Now;
clsReac.ApprovalStatusCode = (int)ApprovalStatus.Pending;
clsReac.LastUpdateDate = new DateTime(1900, 1, 1);
clsReac.LastUpdateUser = "";
clsReac.ApprovalActionUser = "";
clsReac.ApprovalActionDate = new DateTime(1900, 1, 1);
clsReac.intPreviousStatusCode = infoMember.intStatusCode;
}
else if (id != 0)
{
clsReac.CreatedBy = Dynamics.Globals.UserId;
clsReac.CreationDate = DateTime.Now;
clsReac.ApprovalStatusCode = (int)approvalStatus;
clsReac.LastUpdateDate = DateTime.Now;
clsReac.LastUpdateUser = Dynamics.Globals.UserId;
if (approvalStatus != ApprovalStatus.Pending)
{
clsReac.ApprovalActionUser = Dynamics.Globals.UserId;
clsReac.ApprovalActionDate = DateTime.Now;
}
else
{
clsReac.ApprovalActionUser = "";
clsReac.ApprovalActionDate = new DateTime(1900, 1, 1);
}
}
bool result = da.AddReActivation(clsReac);
if (result == false)
{
MessageBox.Show("An Error Occurred.");
return;
}
infoMember.RegistrationNo = txtRegistrationNo.Text;
infoMember.ClientID = txtClientID.Text;
if (approvalStatus == ApprovalStatus.Approved)
{
infoMember.intStatusCode = (int)memberLookupCodes.Reactivate;
}
else if (approvalStatus == ApprovalStatus.Pending)
{
infoMember.intStatusCode = (int)memberLookupCodes.MarkedForReactivation;
}
result = da.UpdateMemberRegistrationAfterCancellation(infoMember);
if (result == false)
{
MessageBox.Show("An Error Occured");
return;
}
if (result == true)
{
MessageBox.Show("Reactivation successful.");
Clear();
}
}
