public List <clsTransferHistory> GetAllTransferHistoryList(clsDocumentFilter clsdoc)
{
List <clsTransferHistory> lst = new List <clsTransferHistory>();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetAllTransferHistory"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@RegistrationNo", clsdoc.strRegistrationNo);
// cmd.Parameters.AddWithValue("@ProjectID", clsdoc.strProjectID);
cmd.Parameters.AddWithValue("@TransferFromID", clsdoc.strClientID);
cmd.Parameters.AddWithValue("@TransferToID", clsdoc.strToClientID);
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 clsTransferHistory();
info.intID = Convert.ToInt32(reader["ID"].ToString());
info.strRegistrationNo = reader["RegistrationNo"].ToString();
info.strTransferFromID = reader["TransferFromID"].ToString();
info.strTransferToID = reader["TransferToID"].ToString();
info.dtTransferDate = Convert.ToDateTime(reader["TransferDate"]);
info.ApprovalStatusCode = Convert.ToInt32(reader["ApprovalStatusCode"].ToString());
info.ApprovalStatusDescription = reader["ApprovalStatusDescription"].ToString();
info.ApprovalActionUser = reader["ApprovalActionUser"].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.strName = reader["Name"].ToString();
info.strFatherOrHusbandType = reader["FatherOrHusbandType"].ToString();
info.strFatherOrHusband = reader["FatherOrHusbandName"].ToString();
info.strNIDOrCNIC = reader["CNIC"].ToString();
info.strNationality = reader["Nationality"].ToString();
info.dtDOB = Convert.ToDateTime(reader["DOB"].ToString());
info.strCurrentAddress1 = reader["CurrentAddress1"].ToString();
info.strCurrentAddress2 = reader["CurrentAddress2"].ToString();
info.strCurrentAddress3 = reader["CurrentAddress3"].ToString();
info.strCountry = reader["Country"].ToString();
info.strCity = reader["City"].ToString();
info.strPhOff = reader["PhOff"].ToString();
info.strRes = reader["Res"].ToString();
info.strMob = reader["Mob"].ToString();
info.strEmailAddress = reader["EmailAddress"].ToString();
lst.Add(info);
}
conn.Close();
}
}
return(lst);
}
public clsTransferHistory GetTransferHistoryById(int id)
{
clsTransferHistory info = new clsTransferHistory();
try
{
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetTransferHistoryByID"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@ID", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows == false)
{
info = null;
}
while (reader.Read())
{
info = new clsTransferHistory();
info.intID = Convert.ToInt32(reader["ID"].ToString());
info.strRegistrationNo = reader["RegistrationNo"].ToString();
info.strTransferFromID = reader["TransferFromID"].ToString();
info.strTransferToID = reader["TransferToID"].ToString();
info.dtTransferDate = Convert.ToDateTime(reader["TransferDate"]);
info.strName = reader["Name"].ToString();
info.strFatherOrHusbandType = reader["FatherOrHusbandType"].ToString();
info.strFatherOrHusband = reader["FatherOrHusbandName"].ToString();
info.strNIDOrCNIC = reader["CNIC"].ToString();
info.strNationality = reader["Nationality"].ToString();
info.dtDOB = Convert.ToDateTime(reader["DOB"].ToString());
info.strCurrentAddress1 = reader["CurrentAddress1"].ToString();
info.strCurrentAddress2 = reader["CurrentAddress2"].ToString();
info.strCurrentAddress3 = reader["CurrentAddress3"].ToString();
info.strCountry = reader["Country"].ToString();
info.strCity = reader["City"].ToString();
info.strPhOff = reader["PhOff"].ToString();
info.strRes = reader["Res"].ToString();
info.strMob = reader["Mob"].ToString();
//info.strFax = reader["Fax"].ToString();
info.strEmailAddress = reader["EmailAddress"].ToString();
info.ApprovalStatusCode = Convert.ToInt32(reader["ApprovalStatusCode"].ToString());
info.ApprovalStatusDescription = reader["ApprovalStatusDescription"].ToString();
info.ApprovalActionUser = reader["ApprovalActionUser"].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"]);
}
conn.Close();
}
}
}
catch (Exception exc)
{
info = null;
}
finally { }
return(info);
}
private void SaveTransfer(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;
}
bool result;
var info1 = new clsTransferHistory();
info1.intID = this.id;
info1.strRegistrationNo = txtRegistration.Text.Trim();
info1.strTransferFromID = txtClientID.Text;
info1.strTransferToID = txtTransferID.Text;
info1.dtTransferDate = dtptransferDate.Value;
info1.strName = txtTransferName.Text;
info1.strFatherOrHusbandType = cmbTransferFatherHusband.Text;
info1.strFatherOrHusband = txtTransferFatherHusband.Text;
info1.strNIDOrCNIC = txtNIDCNIC.Text;
info1.strNationality = cmbTransferNationality.Text;
info1.dtDOB = dTPTransferDOB.Value;
info1.strCurrentAddress1 = txtTransferCurrentAddress1.Text.Trim();
info1.strCurrentAddress2 = txtTransferCurrentAddress2.Text.Trim();
info1.strCurrentAddress3 = txtTransferCurrentAddress3.Text.Trim();
info1.strCountry = cmbTransferCountry.Text;
info1.strCity = txtTransferCity.Text;
info1.strPhOff = txtTransferPh.Text;
info1.strRes = txtTransferRes.Text;
info1.strMob = txtTransferMob.Text;
info1.strFax = "";
info1.strEmailAddress = txtTransferEmailAddress.Text;
/////////////
if (id == 0)
{
info1.CreatedBy = Dynamics.Globals.UserId;
info1.CreationDate = DateTime.Now;
info1.ApprovalStatusCode = (int)ApprovalStatus.Pending;
info1.LastUpdateDate = new DateTime(1900, 1, 1);
info1.LastUpdateUser = "";
info1.ApprovalActionUser = "";
info1.ApprovalActionDate = new DateTime(1900, 1, 1);
info1.intPreviousStatusCode = infoMember.intStatusCode;
}
else if (id != 0)
{
info1.CreatedBy = Dynamics.Globals.UserId;
info1.CreationDate = DateTime.Now;
info1.LastUpdateDate = DateTime.Now;
info1.LastUpdateUser = Dynamics.Globals.UserId;
info1.ApprovalStatusCode = (int)approvalStatus;
if (approvalStatus != ApprovalStatus.Pending)
{
info1.ApprovalActionUser = Dynamics.Globals.UserId;
info1.ApprovalActionDate = DateTime.Now;
}
else
{
info1.ApprovalActionUser = "";
info1.ApprovalActionDate = new DateTime(1900, 1, 1);
}
}
int intTransID = 0;
result = da.AddTransferHistory(info1, ref intTransID);
if (result == false)
{
MessageBox.Show("An Error Occoured");
return;
}
infoMember.RegistrationNo = txtRegistration.Text;
infoMember.ClientID = txtClientID.Text;
infoMember.ClientID = txtTransferID.Text;
infoMember.RegistrationNo = txtRegistration.Text.Trim();
infoMember.ClientID = txtTransferID.Text;
infoMember.Name = txtTransferName.Text;
infoMember.FatherOrHusbandType = cmbTransferFatherHusband.Text;
infoMember.FatherOrHusband = txtTransferFatherHusband.Text;
infoMember.NIDOrCNIC = txtNIDCNIC.Text;
infoMember.Nationality = cmbTransferNationality.Text;
infoMember.DOB = dTPTransferDOB.Value;
infoMember.CurrentAddress1 = txtTransferCurrentAddress1.Text.Trim();
infoMember.CurrentAddress2 = txtTransferCurrentAddress2.Text.Trim();
infoMember.CurrentAddress3 = txtTransferCurrentAddress3.Text.Trim();
infoMember.Country = cmbTransferCountry.Text;
infoMember.City = txtTransferCity.Text;
infoMember.PhOff = txtTransferPh.Text;
infoMember.Res = txtTransferRes.Text;
infoMember.Mob = txtTransferMob.Text;
infoMember.Fax = "";
infoMember.EmailAddress = txtTransferEmailAddress.Text;
if (approvalStatus == ApprovalStatus.Approved)
{
infoMember.intStatusCode = (int)memberLookupCodes.Transferred;
}
else if (approvalStatus == ApprovalStatus.Pending)
{
infoMember.intStatusCode = (int)memberLookupCodes.MarkedForTransfer;
}
result = da.UpdateRegistrationonTransfer(infoMember, txtClientID.Text);
if (result == false)
{
MessageBox.Show("An Error Occured");
return;
}
if ((approvalStatus == ApprovalStatus.Pending))
{
if (pbTransferToImage.Image == null)
{
return;
}
clsTransferImage memberImage = new clsTransferImage()
{
TransferID = intTransID,
ClientID = txtTransferID.Text,
ImageId = txtPictureName.Text,
RegistrationNo = txtRegistration.Text
};
memberImage.Image = imageToByteArray(this.pbTransferToImage.Image);
da.AddTransferImage(memberImage);
if (pbTransferToCNIC.Image == null)
{
return;
}
clsTransferCNIC memberCNIC = new clsTransferCNIC()
{
TransferID = intTransID,
ClientID = txtTransferID.Text,
ImageId = txtCNICName.Text,
RegistrationNo = txtRegistration.Text
};
memberCNIC.Image = imageToByteArray(this.pbTransferToCNIC.Image);
da.AddTransferCNIC(memberCNIC);
}
else if ((approvalStatus == ApprovalStatus.Approved))
{
da.AddMemberImageonTransfer(intTransID);
da.AddMemberCNIConTransfer(intTransID);
}
Clear();
}
public bool AddTransferHistory(clsTransferHistory info, ref int id)
{
int st = 0;
try
{
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
{
using (SqlCommand cmd = new SqlCommand("TMR_USP_AddTransferHistory"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@RegistrationNo", info.strRegistrationNo);
cmd.Parameters.AddWithValue("@TransferFromID", info.strTransferFromID);
cmd.Parameters.AddWithValue("@TransferToID", info.strTransferToID);
cmd.Parameters.AddWithValue("@TransferDate", info.dtTransferDate);
cmd.Parameters.AddWithValue("@Name", info.strName);
cmd.Parameters.AddWithValue("@FatherOrHusbandType", info.strFatherOrHusbandType);
cmd.Parameters.AddWithValue("@FatherOrHusbandName", info.strFatherOrHusband);
cmd.Parameters.AddWithValue("@CNIC", info.strNIDOrCNIC);
cmd.Parameters.AddWithValue("@Nationality", info.strNationality);
cmd.Parameters.AddWithValue("@DOB", info.dtDOB);
cmd.Parameters.AddWithValue("@CurrentAddress1", info.strCurrentAddress1);
cmd.Parameters.AddWithValue("@CurrentAddress2", info.strCurrentAddress2);
cmd.Parameters.AddWithValue("@CurrentAddress3", info.strCurrentAddress3);
cmd.Parameters.AddWithValue("@Country", info.strCountry);
cmd.Parameters.AddWithValue("@City", info.strCity);
cmd.Parameters.AddWithValue("@PhOff", info.strPhOff);
cmd.Parameters.AddWithValue("@Res", info.strRes);
cmd.Parameters.AddWithValue("@Mob", info.strMob);
cmd.Parameters.AddWithValue("@EmailAddress", info.strEmailAddress);
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("@ID", info.intID);
SqlParameter parm = new SqlParameter();
parm.ParameterName = "@Outid";
parm.SqlDbType = SqlDbType.Int;
parm.Direction = ParameterDirection.Output;
//parm.Value = info.id;
cmd.Parameters.Add(parm);
st = cmd.ExecuteNonQuery();
id = (int)parm.Value;
}
}
conn.Close();
}
}
catch (Exception ex) { }
if (st > 0)
{
return(true);
}
else
{
return(false);
}
}
private void frmTransfer_Load(object sender, EventArgs e)
{
clsTransferHistory clsTrn = new clsTransferHistory();
cmbApprovalStatus.Text = "Not Saved";
if (id != 0)
{
bEdit = true;
clsTrn = da.GetTransferHistoryById(id);
//Transfer From
var v = da.GetMemberRegistrationInfoByMembershipAndCNIC(clsTrn.strRegistrationNo, clsTrn.strTransferFromID);
/////Disabling
btnSelect.Enabled = false;
txtClientID.Text = v.ClientID;
txtName.Text = v.Name;
cBFatherHusband.Text = v.FatherOrHusbandType;
txtFatherHusband.Text = v.FatherOrHusband;
txtNIDCNIC.Text = v.NIDOrCNIC;
cmbNationality.Text = v.Nationality;
dTPDOB.Value = v.DOB;
txtCurrentAddress1.Text = v.CurrentAddress1;
txtCurrentAddress2.Text = v.CurrentAddress2;
txtCurrentAddress3.Text = v.CurrentAddress3;
cmbCountry.Text = v.Country.ToString().ToUpper();
txtCity.Text = v.City.ToString().ToUpper();
txtPh.Text = v.PhOff;
txtRes.Text = v.Res;
txtMob.Text = v.Mob;
txtFax.Text = v.Fax;
txtEmailAddress.Text = v.EmailAddress;
// Transfer TO
txtTransferID.Text = clsTrn.strTransferToID;
txtTransferName.Text = clsTrn.strName;
cmbTransferFatherHusband.Text = clsTrn.strFatherOrHusbandType;
txtTransferFatherHusband.Text = clsTrn.strFatherOrHusband;
cmbTransferNationality.Text = clsTrn.strNationality;
dTPTransferDOB.Value = clsTrn.dtDOB;
txtTransferCurrentAddress1.Text = clsTrn.strCurrentAddress1;
txtTransferCurrentAddress2.Text = clsTrn.strCurrentAddress2;
txtTransferCurrentAddress3.Text = clsTrn.strCurrentAddress3;
cmbTransferCountry.Text = clsTrn.strCountry.ToString().ToUpper();
txtTransferCity.Text = clsTrn.strCity.ToString().ToUpper();
txtTransferPh.Text = clsTrn.strPhOff;
txtTransferRes.Text = clsTrn.strRes;
txtTransferMob.Text = clsTrn.strMob;
txtTransferEmailAddress.Text = clsTrn.strEmailAddress;
txtRegistration.Text = clsTrn.strRegistrationNo;
EntryApproved = (ApprovalStatus)clsTrn.ApprovalStatusCode;
if ((ApprovalStatus)clsTrn.ApprovalStatusCode == ApprovalStatus.Pending)
{
cmbApprovalStatus.Text = "Pending";
}
else if ((ApprovalStatus)clsTrn.ApprovalStatusCode == ApprovalStatus.Approved)
{
cmbApprovalStatus.Text = "Approved";
}
else if ((ApprovalStatus)clsTrn.ApprovalStatusCode == ApprovalStatus.Rejected)
{
cmbApprovalStatus.Text = "Rejected";
}
txtBlock.Text = v.Block;
txtPlot.Text = v.Plot;
txtProject.Text = v.strProjectid;
txtUnitID.Text = v.Plot;
LoadTransferImage();
LoadMemberImage();
}
}