//public bool Insert(string T_ENTRY_USER, t12135 T12135)
//{
// return Command($"INSERT INTO T12135 (T_ENTRY_USER,T_ENTRY_DATE,T_CENTRIFUGE_MACHINE_CODE,T_PROGRAM_CODE,T_UNIT_NO,T_PROD_CODE) VALUES ('{T_ENTRY_USER}',SYSDATE,'{T12135.T_CENTRIFUGE_MACHINE_CODE}','{T12135.T_PROGRAM_CODE}','{T12135.T_UNIT_NO}','{T12135.T_PROD_CODE}')");
//}
public bool Insert(string T_ENTRY_USER, t12135 T12135)
{
//BLOOD_GROUP,ANTIBODY,VERIFY,DU,SEG_BLOOD
//Command($"INSERT INTO T12135 (T_ENTRY_USER,T_ENTRY_DATE,T_CENTRIFUGE_MACHINE_CODE,T_PROGRAM_CODE,T_UNIT_NO,T_PROD_CODE,T_PROD_EXPIRY_DATE,T_DONATION_DATE,T_CHECK_FLAG) VALUES ('{T_ENTRY_USER}',SYSDATE,'{T12135.T_CENTRIFUGE_MACHINE_CODE}','{T12135.T_PROGRAM_CODE}','{T12135.T_UNIT_NO}','{T12135.T_PROD_CODE}',to_date(SUBSTR('{T12135.T_PROD_EXPIRY_DATE}', 0, 10), 'DD/MM/yyyy'),to_date(SUBSTR('{T12135.T_DONATION_DATE}', 0, 10), 'DD/MM/yyyy'),'{T12135.T_CHECK_FLAG}')");
Command($"INSERT INTO T12135 (T_ENTRY_USER,T_ENTRY_DATE,T_CENTRIFUGE_MACHINE_CODE,T_PROGRAM_CODE,T_UNIT_NO,T_PROD_CODE,T_PROD_EXPIRY_DATE,T_DONATION_DATE,T_CHECK_FLAG) VALUES ('{T_ENTRY_USER}',TRUNC(SYSDATE),'{T12135.T_CENTRIFUGE_MACHINE_CODE}','{T12135.T_PROGRAM_CODE}','{T12135.T_UNIT_NO}','{T12135.T_PROD_CODE}','{T12135.T_PROD_EXPIRY_DATE.ToString("dd-MMM-yyyy")}','{T12135.T_DONATION_DATE.ToString("dd-MMM-yyyy")}','{T12135.T_CHECK_FLAG}')");
DataTable dt = new DataTable();
dt = Query($"SELECT DISTINCT T_ABO_CODE,T_ANTIBODY_1,T_VERIFY,T_DU,T_SEG_ABO,T_PRODUCT_CODE FROM T12019 WHERE T_UNIT_NO='{T12135.T_UNIT_NO}' AND T_PRODUCT_CODE!='{T12135.T_PROD_CODE}'");
string BLOOD_GROUP = dt.Rows[0]["T_ABO_CODE"].ToString();
string ANTIBODY = dt.Rows[0]["T_ANTIBODY_1"].ToString();
string VERIFY = dt.Rows[0]["T_VERIFY"].ToString();
string DU = dt.Rows[0]["T_DU"].ToString();
string SEG_BLOOD = dt.Rows[0]["T_SEG_ABO"].ToString();
string PROD_COD = dt.Rows[0]["T_PRODUCT_CODE"].ToString();
if (PROD_COD != "NSFS")
{
Command($"INSERT INTO t12019 (t_entry_date, t_entry_user, t_destroy_flag, t_donation_date, t_expiry_date, t_product_code, t_reject_flag, t_unit_no,T_UNIT_SEPERATION_DATE, T_ABO_CODE, T_ANTIBODY_1, T_VERIFY, T_DU, T_SEG_ABO, T_BLOOD_BAG_GROUP) VALUES (TRUNC(SYSDATE),'{T_ENTRY_USER}', '2','{T12135.T_DONATION_DATE.ToString("dd-MMM-yyyy")}','{T12135.T_PROD_EXPIRY_DATE.ToString("dd-MMM-yyyy")}','{T12135.T_PROD_CODE}','2','{T12135.T_UNIT_NO}', TRUNC(SYSDATE),'{BLOOD_GROUP}', '{ANTIBODY}','{VERIFY}','{DU}','{SEG_BLOOD}','{BLOOD_GROUP}')");
return(true);
}
//to_date(SUBSTR('31/10/2018 12:00:00 AM', 0, 10), 'DD/MM/yyyy')
else
{
return(false);
//---------------Commneted for check -------------------
//Command($"INSERT INTO t12019 (t_entry_date, t_entry_user, t_destroy_flag, t_donation_date, t_expiry_date, t_product_code, t_reject_flag, t_unit_no,T_UNIT_SEPERATION_DATE,T_UNIT_STATUS, T_ABO_CODE, T_ANTIBODY_1, T_VERIFY, T_DU, T_SEG_ABO, T_BLOOD_BAG_GROUP) VALUES (TRUNC(SYSDATE),'{T_ENTRY_USER}', '2','{T12135.T_DONATION_DATE.ToString("dd-MMM-yyyy")}','{T12135.T_PROD_EXPIRY_DATE.ToString("dd-MMM-yyyy")}','{T12135.T_PROD_CODE}','2','{T12135.T_UNIT_NO}', TRUNC(SYSDATE),'10','{BLOOD_GROUP}', '{ANTIBODY}','{VERIFY}','{DU}','{SEG_BLOOD}','{BLOOD_GROUP}')");
}
}
public ActionResult Insert(t12135 T12135)
{
try
{
string user = HttpContext.Session["T_EMP_CODE"].ToString();
var data = repository.Insert(user, T12135);
string JSONString = string.Empty;
JSONString = JsonConvert.SerializeObject(data);
return(Json(JSONString, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
err.SetServerErrorLog(ControllerContext.RouteData.Values["controller"].ToString(),
ControllerContext.RouteData.Values["action"].ToString(),
Session["T_ENTRY_USER"] == null ? "" : Session["T_ENTRY_USER"].ToString(), e.Message);
return(Json(e.Message, JsonRequestBehavior.AllowGet));
}
}
//public DataTable GetGridDataList()
//{
// var Data = obj.GetGridDataList();
// return Data;
//}
public string Insert(string user, t12135 T12135)
{
string msg = "";
try
{
obj.BeginTransaction();
if (obj.Insert(user, T12135))
{
obj.CommitTransaction();
msg = "Data Saved Successfully";
}
else
{
obj.RollbackTransaction();
msg = "Data Not Saved";
}
}
catch (Exception e)
{
MethodBase m = MethodBase.GetCurrentMethod();
obj.Log(m.ReflectedType.Name + "." + m.Name, "1", e.Message);
}
//obj.BeginTransaction();
//if (obj.Insert(user, T12135))
//{
// obj.CommitTransaction();
// msg = "Data Saved Successfully";
//}
//else
//{
// obj.RollbackTransaction();
// msg = "Data Not Saved";
//}
return(msg);
}
