public ENT.DMT_Documents GetByUserId(Guid guid)
{
ENT.DMT_Documents Entity = new ENT.DMT_Documents();
try
{
parFields.Clear();
//Add Query in to string builder object
QueryDisctionery.SelectPart = "select top 1 * ";
QueryDisctionery.TablePart = @"from DMT_Documents ";
QueryDisctionery.ParameterPart = "Where dd_userid='" + guid + "'";
QueryDisctionery.OrderPart = "order by CreatedDateTime desc";
//Execute Query and get SQLDataReader
using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity))
{
Entity = COM.DBHelper.CopyDataReaderToSingleEntity <ENT.DMT_Documents>(dr);
objDBHelper.Disposed();
}
}
catch (Exception)
{
throw;
}
finally
{
parFields.Clear();
}
return(Entity);
}
public JsonResult GetStatus()
{
int status = 0;
ENT.DMT_Documents dMT_Documents = null;
using (BAL.DMT_Documents objBal = new BAL.DMT_Documents())
{
dMT_Documents = objBal.GetByUserId(_LoginUserId);
}
if (dMT_Documents == null)
{
status = 1;
}
else
{
if (dMT_Documents.dd_status == 1)
{
status = 2;
}
else if (dMT_Documents.dd_status == 2)
{
status = 3;
}
else
{
status = 4;
}
}
return(Json(status, JsonRequestBehavior.AllowGet));
}
// this function for just referance for partial update field user have to create seperate function learn from this function.
public bool UpdatePartial(ENT.DMT_Documents objEntity)
{
bool blnResult = false;
try
{
//Create Fields List in dictionary
Dictionary <string, bool> dctFields = new Dictionary <string, bool>();
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.dd_id), true);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.dd_userid), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.dd_page1), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.dd_page2), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.dd_type), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.dd_status), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.dd_remarks), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.SystemDateTime), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.CreatedBy), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.CreatedDateTime), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.UpdatedBy), false);
dctFields.Add(COM.HelperMethod.PropertyName <ENT.DMT_Documents>(x => x.UpdatedDateTime), false);
objEntity.FieldCollection = dctFields;
if (objDAL.SaveChanges(objEntity.FieldCollection, objEntity))
{
blnResult = true;
}
}
catch (Exception)
{
throw;
}
return(blnResult);
}
public JsonResult SaveEntry(string backimage, string frontimage, int dd_type)
{
ENT.DMT_Documents model = new ENT.DMT_Documents();
try
{
if (String.IsNullOrEmpty(frontimage))
{
GlobalVarible.AddError("Please select Front Image.");
return(Json(MySession.Current.MessageResult));
}
else
{
model.dd_page1 = SaveDmtDocument(frontimage);
}
if (String.IsNullOrEmpty(backimage))
{
model.dd_page2 = string.Empty;
}
else
{
model.dd_page2 = SaveDmtDocument(backimage);
}
model.dd_status = (int)COM.MyEnumration.DMTDOCUMENTSTATUS.PENDING;
model.dd_remarks = string.Empty;
model.CreatedDateTime = DateTime.Now;
model.CreatedBy = _LoginUserId;
model.dd_userid = _LoginUserId;
model.dd_type = dd_type;
using (BAL.DMT_Documents objBAL = new BAL.DMT_Documents())
{
if (objBAL.Insert(model))
{
GlobalVarible.AddMessage("User document saved successfully.");
}
else
{
GlobalVarible.AddError("Unable to save user document");
}
}
}
catch (Exception ex)
{
GlobalVarible.AddError(ex.Message);
}
MySession.Current.MessageResult.MessageHtml = GlobalVarible.GetMessageHTML();
return(Json(MySession.Current.MessageResult, JsonRequestBehavior.AllowGet));
}
public JsonResult ApproveRequest(string id)
{
GlobalVarible.Clear();
try
{
if (id != null)
{
ENT.DMT_Documents Entity = new ENT.DMT_Documents();
using (BAL.DMT_Documents objBAL = new BAL.DMT_Documents())
{
objBAL.Entity.dd_id = Guid.Parse(id);
Entity = (ENT.DMT_Documents)objBAL.GetByPrimaryKey(objBAL.Entity);
objBAL.Entity.dd_status = (int)COM.MyEnumration.DMTDOCUMENTSTATUS.APPROVED;
objBAL.Entity.UpdatedBy = _LoginUserId;
objBAL.Entity.UpdatedDateTime = DateTime.Now;
if (objBAL.UpdateApprove(objBAL.Entity))
{
using (BAL.DMT_Approval dMT_Approval = new BAL.DMT_Approval())
{
dMT_Approval.Entity.approval_userid = Entity.dd_userid;
dMT_Approval.Entity.approval_status = (int)COM.MyEnumration.DMTAPPROVALSTATUS.APPROVED;
dMT_Approval.Entity.CreatedBy = _LoginUserId;
dMT_Approval.Entity.CreatedDateTime = DateTime.Now;
if (dMT_Approval.Insert(dMT_Approval.Entity))
{
GlobalVarible.AddMessage("Request Approved Successfully.");
}
}
GlobalVarible.AddMessage("Request Approved Successfully.");
}
else
{
GlobalVarible.AddMessage("Unable to Approve Request.");
}
}
}
else
{
GlobalVarible.AddMessage("Unable Approve Request.");
}
}
catch (Exception ex)
{
GlobalVarible.AddError(ex.Message);
}
MySession.Current.MessageResult.MessageHtml = GlobalVarible.GetMessageHTML();
return(Json(MySession.Current.MessageResult, JsonRequestBehavior.AllowGet));
}
public object GetByPrimaryKey(ENT.DMT_Documents Entity)
{
object objResult = null;
try
{
DAL.CRUDOperation tt = new DAL.CRUDOperation();
objResult = tt.GetEntityByPrimartKey(Entity);
}
catch (Exception)
{
throw;
}
return(objResult);
}
public ENT.DMT_Documents GetByUserId(Guid guid)
{
ENT.DMT_Documents Entity = new ENT.DMT_Documents();
Entity = clsDAL.GetByUserId(guid);
return(Entity);
}