public int SaveApproverSign(ApproverMaster pOCO)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("SaveApproverSign", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ApproverUserId", pOCO.ApproverUserId);
cmd.Parameters.AddWithValue("@SignImagePath", pOCO.SignImagePath.ToString());
cmd.Parameters.AddWithValue("@Name", DBNull.Value);
cmd.Parameters.AddWithValue("@Position", pOCO.Position.ToString());
//cmd.Parameters.AddWithValue("@CreatedOn", pOCO.CreatedOn1.ToString());
//cmd.Parameters.AddWithValue("@ModifiedOn", pOCO.ModifiedOn1.ToString());
if (pOCO.Id > 0)
{
cmd.Parameters.AddWithValue("@Id ", pOCO.Id);
}
else
{
cmd.Parameters.AddWithValue("@Id ", DBNull.Value);
}
int recordsAffected = cmd.ExecuteNonQuery();
con.Close();
return(recordsAffected);
}
public void GetAllUserForDrpApproverSign()
{
ApproverSignBL bL = new ApproverSignBL();
List <ApproverMaster> pocoList = new List <ApproverMaster>();
pocoList = bL.GetAllUserForDrpApproverSign(/*int.Parse(Session["VesselID"].ToString())*/);
List <ApproverMaster> itmasterList = new List <ApproverMaster>();
foreach (ApproverMaster up in pocoList)
{
ApproverMaster unt = new ApproverMaster();
unt.UserId = up.UserId;
unt.UserName = up.UserName;
itmasterList.Add(unt);
}
ViewBag.Users = itmasterList.Select(x =>
new SelectListItem()
{
Text = x.UserName,
Value = x.UserId.ToString()
});
}
public int SaveApprover(ApproverMaster approver)
{
int recorSaved = 0;
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand cmd = new SqlCommand("SaveApprover", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", approver.ID);
cmd.Parameters.AddWithValue("@ShipId", approver.ShipId);
cmd.Parameters.AddWithValue("@IMONumber", approver.VesselIMONumber);
cmd.Parameters.AddWithValue("@RankId", approver.RankId);
cmd.Parameters.AddWithValue("@UserId", approver.UserId);
//cmd.Parameters.AddWithValue("@ApproverId", approver.ApproverId);
cmd.Parameters.AddWithValue("@CreatedBy", 1);
if (approver.ApproverId != 0)
{
cmd.Parameters.AddWithValue("@ApproverId", approver.ApproverId);
}
else
{
cmd.Parameters.AddWithValue("@ApproverId", 0);
}
recorSaved = cmd.ExecuteNonQuery();
con.Close();
return(recorSaved);
}
/// <summary>
/// Added on 23th jul 2021 @BK
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public ApproverMaster GetApproverUserByApproverUserId(int UserId)
{
ApproverMaster approver = new ApproverMaster();
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetApproverUserByUserId", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ApproverUserId", UserId);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
con.Close();
approver.ApproverUserId = Convert.ToInt32(ds.Tables[0].Rows[0]["ApproverUserId"].ToString());
approver.Position = ds.Tables[0].Rows[0]["Position"].ToString();
approver.Name = ds.Tables[0].Rows[0]["Name"].ToString();
approver.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
}
}
return(approver);
}
public List <ApproverMaster> GetAllApproverListPageWise(int pageIndex, ref int totalCount, int pageSize)
{
List <ApproverMaster> approverList = new List <ApproverMaster>();
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("GetAllApproverListPageWise", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
cmd.Parameters.AddWithValue("@PageSize", pageSize);
cmd.Parameters.Add("@TotalCount", SqlDbType.Int, 4);
cmd.Parameters["@TotalCount"].Direction = ParameterDirection.Output;
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
ApproverMaster approver = new ApproverMaster();
approver.ID = Convert.ToInt32(dr["ID"]);
approver.ShipId = Convert.ToInt32(dr["ShipId"]);
approver.RankId = Convert.ToInt32(dr["RankId"]);
approver.UserId = Convert.ToInt32(dr["UserId"]);
approver.ApproverId = Convert.ToInt32(dr["ApproverId"]);
approver.VesselIMONumber = Convert.ToInt32(dr["VesselIMONumber"]);
Ship ship = new Ship();
ship.ID = Convert.ToInt32(dr["ID"]);
ship.ShipName = Convert.ToString(dr["ShipName"]);
approver.Ship = ship;
RankPOCO rank = new RankPOCO();
rank.RankId = Convert.ToInt32(dr["RankId"]);
rank.RankName = Convert.ToString(dr["RankName"]);
approver.Rank = rank;
UserMasterPOCO user = new UserMasterPOCO();
user.UserId = Convert.ToInt32(dr["UserId"]);
user.UserName = Convert.ToString(dr["UserName"]);
approver.User = user;
approver.ApproverDescription = Convert.ToString(dr["ApproverDescription"]);
approver.RowNumber = Convert.ToInt32(dr["RowNumber"]);
approverList.Add(approver);
}
totalCount = Convert.ToInt32(cmd.Parameters["@TotalCount"].Value);
con.Close();
}
}
return(approverList);
}
/// <summary>
/// Old / for single approver
/// </summary>
/// <param name="approver"></param>
/// <returns></returns>
public JsonResult SaveApprover(ApproverMaster approver)
{
ApproverMasterBL approverBL = new ApproverMasterBL();
int rowaffected = approverBL.SaveApprover(approver);
return(Json(rowaffected, JsonRequestBehavior.AllowGet));
}
public JsonResult GetApproverUserByApproverUserId(string userId)
{
ApproverMaster approver = new ApproverMaster();
ApproverMasterBL userBl = new ApproverMasterBL();
approver = userBl.GetApproverUserByApproverUserId(Convert.ToInt32(userId));
//approver.RankId = user.RankId;
//approver.User = user;
return(Json(approver, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// this method used to get Rank by UserId
/// and call from JS on change User
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public JsonResult GetUserDetailsByUser(string userId)
{
ApproverMaster approver = new ApproverMaster();
UserMasterBL userBl = new UserMasterBL();
UserMasterPOCO user = new UserMasterPOCO();
user = userBl.GetUserByUserId(Convert.ToInt32(userId));
approver.RankId = user.RankId;
approver.User = user;
return(Json(approver, JsonRequestBehavior.AllowGet));
}
public JsonResult GetIMONumberByShip(string shipId)
{
ApproverMaster approver = new ApproverMaster();
ShipBL shipBL = new ShipBL();
Ship ship = new Ship();
ship = shipBL.GetShipDetailsById(Convert.ToInt32(shipId));
approver.VesselIMONumber = ship.IMONumber;
approver.Ship = ship;
return(Json(approver, JsonRequestBehavior.AllowGet));
}
private ApproverMaster ConvertDataTableToApproverSignByIdList(DataSet ds)
{
ApproverMaster pPOCOPC = new ApproverMaster();
//check if there is at all any data
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
//RankPOCO pPOCOPC = new RankPOCO();
//if (item["Id"] != null)
// pPOCOPC.Id = Convert.ToInt32(item["Id"].ToString());
if (item["ApproverUserId"] != System.DBNull.Value)
{
pPOCOPC.ApproverUserId = Convert.ToInt32(item["ApproverUserId"].ToString());
}
if (item["UserName"] != System.DBNull.Value)
{
pPOCOPC.Name = item["UserName"].ToString();
}
if (item["SignImagePath"] != System.DBNull.Value)
{
pPOCOPC.SignImagePath = item["SignImagePath"].ToString();
}
if (item["Position"] != System.DBNull.Value)
{
pPOCOPC.Position = item["Position"].ToString();
}
//if (item["CreatedOn"] != System.DBNull.Value)
// pPOCOPC.CreatedOn1 = item["CreatedOn"].ToString();
//if (item["ModifiedOn"] != System.DBNull.Value)
// pPOCOPC.ModifiedOn1 = item["ModifiedOn"].ToString();
//pcList.Add(pPOCOPC);
}
pPOCOPC.ApprovedCount = Convert.ToInt32(ds.Tables[1].Rows[0]["ApprovedCount"].ToString());//Approver SL
pPOCOPC.ApproversCount = Convert.ToInt32(ds.Tables[2].Rows[0]["ApproversCount"].ToString());
if (Convert.ToInt32(ds.Tables[3].Rows[0]["IsApprove"].ToString()) > 0)
{
pPOCOPC.IsFinalApproved = Convert.ToInt32(ds.Tables[3].Rows[0]["IsApprove"].ToString());
pPOCOPC.FinalApprovedOn = Convert.ToDateTime(ds.Tables[3].Rows[0]["ApprovedOn"].ToString());
}
}
return(pPOCOPC);
}
public JsonResult LoadData()
{
int draw, start, length;
int pageIndex = 0;
if (null != Request.Form.GetValues("draw"))
{
draw = int.Parse(Request.Form.GetValues("draw").FirstOrDefault().ToString());
start = int.Parse(Request.Form.GetValues("start").FirstOrDefault().ToString());
length = int.Parse(Request.Form.GetValues("length").FirstOrDefault().ToString());
}
else
{
draw = 1;
start = 0;
length = 500;
}
if (start == 0)
{
pageIndex = 1;
}
else
{
pageIndex = (start / length) + 1;
}
ApproverSignBL bL = new ApproverSignBL(); ///////////////////////////////////////////////////////////////////////////
int totalrecords = 0;
List <ApproverMaster> pocoList = new List <ApproverMaster>();
pocoList = bL.GetAllApproverSignPageWise(pageIndex, ref totalrecords, length /*, int.Parse(Session["VesselID"].ToString())*/);
List <ApproverMaster> pList = new List <ApproverMaster>();
foreach (ApproverMaster pC in pocoList)
{
ApproverMaster pOCO = new ApproverMaster();
//pOCO.Id = pC.Id;
pOCO.UserName = pC.UserName;
pOCO.SignImagePath = pC.SignImagePath;
pOCO.Name = pC.Name;
pOCO.Position = pC.Position;
pList.Add(pOCO);
}
var data = pList;
return(Json(new { draw = draw, recordsFiltered = totalrecords, recordsTotal = totalrecords, data = data }, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveApproverSign(ApproverMaster ApproverSign)
{
ApproverSignBL bL = new ApproverSignBL();
ApproverMaster pC = new ApproverMaster();
pC.Id = ApproverSign.Id;
pC.ApproverUserId = ApproverSign.ApproverUserId;
pC.SignImagePath = ApproverSign.SignImagePath;
pC.Name = ApproverSign.Name;
pC.Position = ApproverSign.Position;
//pC.CreatedOn1 = pOCO.CreatedOn1;
//pC.ModifiedOn1 = pOCO.ModifiedOn1;
return(Json(bL.SaveApproverSign(pC /*, int.Parse(Session["VesselID"].ToString())*/), JsonRequestBehavior.AllowGet));
}
public ApproverMaster GetAllApproverSign(int ApproverUserId, string uploadedFormName = null)
{
ApproverMaster prodPOList = new ApproverMaster();
ApproverMaster prodPO = new ApproverMaster();
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetAllApproverSign", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ApproverUserId", ApproverUserId);
cmd.Parameters.AddWithValue("@UploadedFormName", uploadedFormName);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
con.Close();
}
}
return(ConvertDataTableToApproverSignByIdList(ds));
}
public int SaveApprover(ApproverMaster approver)
{
ApproverMasterDAL approverDal = new ApproverMasterDAL();
return(approverDal.SaveApprover(approver));
}
public JsonResult SaveSign(string crewId, string crewPosition)
{
var key = "b14ca5898a4e4133bbce2ea2315a1916";
string fnameWithPath = string.Empty;
List <string> returnMsg = new List <string>();
string fileName = String.Empty; //Path.GetFileNameWithoutExtension(postedFile.FileName);
//fileName = "SignImages" + "_" + crewId;
fileName = "SignImages" + "_" + Session["UserId"].ToString(); // 31-07-2021
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
string fname;
string extn;
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
extn = Path.GetExtension(fname);
}
else
{
fname = file.FileName;
extn = Path.GetExtension(file.FileName);
}
string path = Server.MapPath(ConfigurationManager.AppSettings["SignImagePath"].ToString());
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
if (System.IO.File.Exists(path + fileName))
{
System.IO.File.Delete(path + fileName);
}
//fileName = fileName + ".zip"/*extn*/;
fileName = fileName + extn;
// Get the complete folder path and store the file inside it.
fnameWithPath = Path.Combine(path, fileName);
file.SaveAs(fnameWithPath);
returnMsg.Add(fnameWithPath);
}
ApproverSignBL bL = new ApproverSignBL();
ApproverMaster pC = new ApproverMaster();
pC.ApproverUserId = Convert.ToInt32(int.Parse(Session["UserId"].ToString()));
pC.SignImagePath = AesOperation.EncryptString(key, fnameWithPath);
//pC.Name = name;
pC.Position = crewPosition;
//pC.CreatedOn1 = pOCO.CreatedOn1;
//pC.ModifiedOn1 = pOCO.ModifiedOn1;
int x = bL.SaveApproverSign(pC);
return(Json(returnMsg, JsonRequestBehavior.AllowGet));
}
public int SaveApproverSign(ApproverMaster pOCO)
{
ApproverSignDAL dAL = new ApproverSignDAL();
return(dAL.SaveApproverSign(pOCO));
}
