public DataTable Insert_Update_MasterInfo(string procedure, string callname, FinisgingProductionMaster objMaster)
{
dbConn = new SqlConnection(ConnectionString);
dbConn.Open();
cmd = new SqlCommand(procedure, dbConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@call_name", callname));
cmd.Parameters.Add(new SqlParameter("@FID", objMaster.FID));
cmd.Parameters.Add(new SqlParameter("@FDate", objMaster.FDate.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@ShiftCode", objMaster.ShiftCode));
cmd.Parameters.Add(new SqlParameter("@Shift", objMaster.Shift));
cmd.Parameters.Add(new SqlParameter("@Remarks", objMaster.Remarks));
cmd.Parameters.Add(new SqlParameter("@UserName", objMaster.UserName));
cmd.Parameters.Add(new SqlParameter("@MCRunTime", objMaster.MCRunTime));
cmd.Parameters.Add(new SqlParameter("@MCOffTime", objMaster.MCOffTime));
cmd.Parameters.Add(new SqlParameter("@MCName", objMaster.MCName));
cmd.Parameters.Add(new SqlParameter("@MCCode ", objMaster.MCCode));
cmd.Parameters.Add(new SqlParameter("@PType ", objMaster.PType));
cmd.Parameters.Add(new SqlParameter("@PCode ", objMaster.PCode));
cmd.Parameters.Add(new SqlParameter("@DCode", objMaster.DCode));
cmd.Parameters.Add(new SqlParameter("@DName", objMaster.DName));
cmd.Parameters.Add(new SqlParameter("@UCode", objMaster.UCode));
cmd.Parameters.Add(new SqlParameter("@UName", objMaster.UName));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public ActionResult SaveFinishingMasterInfo(FinisgingProductionMaster objMaster)
{
var user = (User)Session["CurrentUser"];
//objMaster.UserId = user.EMPID;
// objMaster.UName = user.EMPID;
var res = _repository.SaveMasterInfo(objMaster);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public string SaveMasterInfo(FinisgingProductionMaster objMaster)
{
string rv = "";
try
{
var result = Insert_Update_MasterInfo("sp_insert_finishing_Production_master_info", "SAVE_FINISHING_PRODUCTION_MASTER", objMaster);
rv = Operation.Success.ToString();
return(result.Rows[0]["FID"].ToString());
}
catch (Exception ex)
{
rv = ex.Message;
}
return(rv);
}
public string SaveMasterInfo(FinisgingProductionMaster objMaster)
{
return(_service.SaveMasterInfo(objMaster));
}
