public List <clsAllocation> GetAllAllocationList(clsDocumentFilter clsdoc)
{
List <clsAllocation> lst = new List <clsAllocation>();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetAllAllocations"))
{
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 clsAllocation();
info.RegistrationOrBookingNo = reader["RegistrationNo"].ToString();
info.strProjectid = reader["ProjectID"].ToString();
info.strBlock = reader["Block"].ToString();
info.strUnitID = reader["UnitID"].ToString();
info.strClientID = reader["ClientID"].ToString();
info.dtAllocationDate = Convert.ToDateTime(reader["AllocationDate"]);
info.bitApprove = Convert.ToBoolean(reader["Approve"]);
info.strRemarks = reader["Remarks"].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"]);
info.StatusDescription = reader["StatusDescription"].ToString();
info.id = Convert.ToInt32(reader["id"].ToString());
lst.Add(info);
}
conn.Close();
}
}
return(lst);
}
public bool AddAllocationINFO(clsAllocation info)
{
int st = 0;
try
{
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
{
using (SqlCommand cmd = new SqlCommand("TMR_USP_AddAllocation"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@id", info.id);
cmd.Parameters.AddWithValue("@RegistrationNo", info.RegistrationOrBookingNo);
cmd.Parameters.AddWithValue("@ProjectID", info.strProjectid);
cmd.Parameters.AddWithValue("@Block", info.strBlock);
cmd.Parameters.AddWithValue("@UnitID", info.strUnitID);
cmd.Parameters.AddWithValue("@ClientID", info.strClientID);
cmd.Parameters.AddWithValue("@AllocationDate", info.dtAllocationDate);
cmd.Parameters.AddWithValue("@Approve", info.bitApprove);
cmd.Parameters.AddWithValue("@DirectorName", info.strDirector);
cmd.Parameters.AddWithValue("@Remarks", info.strRemarks);
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("@StatusCode", info.intPreviousStatusCode);
st = cmd.ExecuteNonQuery();
}
}
conn.Close();
}
}
catch (Exception ex) { }
if (st > 0)
{
return(true);
}
else
{
return(false);
}
}
public clsAllocation GetAllocationByID(int id)
{
clsAllocation info = new clsAllocation();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetAllocationByID"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
//conn.Open();
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
info.RegistrationOrBookingNo = reader["RegistrationNo"].ToString();
info.strProjectid = reader["ProjectID"].ToString();
info.strBlock = reader["Block"].ToString();
info.strUnitID = reader["UnitID"].ToString();
info.strClientID = reader["ClientID"].ToString();
info.dtAllocationDate = Convert.ToDateTime(reader["AllocationDate"]);
info.bitApprove = Convert.ToBoolean(reader["Approve"].ToString());
info.strRemarks = reader["Remarks"].ToString();
info.strDirector = reader["DirectorName"].ToString();
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.intPreviousStatusCode = Convert.ToInt32(reader["PreviousStatusCode"]);
info.id = Convert.ToInt32(reader["id"]);
}
conn.Close();
}
}
return(info);
}
private void SaveAllocation(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 infoAloc = new clsAllocation();
infoAloc.id = this.id;
infoAloc.strProjectid = cmbProject.Text;
infoAloc.strBlock = cmbBlock.Text;
infoAloc.dtAllocationDate = dTAllocationDate.Value;
infoAloc.RegistrationOrBookingNo = txtRegistrationNo.Text;
infoAloc.strUnitID = txtUnit.Text;
infoAloc.strClientID = txtClientID.Text;
infoAloc.bitApprove = chkBoxApproved.Checked;
infoAloc.strDirector = cmbDirector.Text;
infoAloc.strRemarks = txtRemarks.Text;
if (id == 0)
{
infoAloc.CreatedBy = Dynamics.Globals.UserId;
infoAloc.CreationDate = DateTime.Now;
infoAloc.ApprovalStatusCode = (int)ApprovalStatus.Pending;
infoAloc.LastUpdateDate = new DateTime(1900, 1, 1);
infoAloc.LastUpdateUser = "";
infoAloc.ApprovalActionUser = "";
infoAloc.ApprovalActionDate = new DateTime(1900, 1, 1);
infoAloc.intPreviousStatusCode = infoMember.intStatusCode;
}
else if (id != 0)
{
infoAloc.CreatedBy = Dynamics.Globals.UserId;
infoAloc.CreationDate = DateTime.Now;
infoAloc.LastUpdateDate = DateTime.Now;
infoAloc.LastUpdateUser = Dynamics.Globals.UserId;
infoAloc.ApprovalStatusCode = (int)approvalStatus;
if (approvalStatus != ApprovalStatus.Pending)
{
infoAloc.ApprovalActionUser = Dynamics.Globals.UserId;
infoAloc.ApprovalActionDate = DateTime.Now;
}
else
{
infoAloc.ApprovalActionUser = "";
infoAloc.ApprovalActionDate = new DateTime(1900, 1, 1);
}
}
bool result = da.AddAllocationINFO(infoAloc);
if (result == false)
{
MessageBox.Show("An Error Occured");
return;
}
infoMember.RegistrationNo = txtRegistrationNo.Text;
infoMember.ClientID = txtClientID.Text;
infoMember.strProjectid = cmbProject.Text;
infoMember.Block = cmbBlock.Text;
infoMember.Plan = txtSizeCode.Text;
infoMember.Plot = txtUnit.Text;
infoMember.bitAllocated = true;
// if (this.chkBoxApproved.Checked == true)
if (approvalStatus == ApprovalStatus.Approved)
{
infoMember.intStatusCode = (int)memberLookupCodes.Allocated;
}
else if (approvalStatus == ApprovalStatus.Pending)
{
infoMember.intStatusCode = (int)memberLookupCodes.MarkedForAllocation;
}
infoMember.strDirectorName = cmbDirector.Text;
result = da.UpdateMemberRegistrationAfterAllocation(infoMember);
if (result == false)
{
MessageBox.Show("An Error Occured");
return;
}
#region //////////////////// Unit Status Unit
if (approvalStatus == ApprovalStatus.Approved)
{
result = da.UpdateUnitStatus("Allocated", txtUnit.Text, txtRegistrationNo.Text, (int)unitLookupCodes.Allocated);
}
else if (approvalStatus == ApprovalStatus.Pending)
{
result = da.UpdateUnitStatus("Allocated", txtUnit.Text, txtRegistrationNo.Text, (int)unitLookupCodes.MarkedForAllocation);
}
if (result == false)
{
MessageBox.Show("An Error Occoured While Update Process");
return;
}
if (result == true)
{
MessageBox.Show("Allocation successful.");
}
#endregion
Clear();
}
