public ActionResult AddPharPharmericaCommon(PharmericaCommPhmc pharmericaCommPhmc)
{
TempData["data"] = "";
if (ModelState.IsValid)
{
TempData["data"] = dbCommon.AddPharmacyPharComm(pharmericaCommPhmc, getUserId());
}
if (TempData["data"].ToString() == DBQueries.msgPharmacyCreationSuccess)
{
return(RedirectToAction("PharmacyCreation", new { view = "PharmericaCommPhmc" }));
}
else
{
return(View("PharmericaCommPhmc", pharmericaCommPhmc));
}
}
public string AddPharmacyPharComm(PharmericaCommPhmc objPharComm, string loginId)
{
string result = "";
try
{
string query = string.Format(dbQueries.sqlAddPh_Pmcomn, loginId);
SqlParameter[] sqlParameter = new SqlParameter[20];
sqlParameter[0] = new SqlParameter(DBQueries.sqlPrm_pharcode, System.Data.SqlDbType.VarChar);
sqlParameter[0].Value = objPharComm.PharmacyCode ?? (object)DBNull.Value;
sqlParameter[1] = new SqlParameter(DBQueries.sqlprm_pharname, System.Data.SqlDbType.VarChar);
sqlParameter[1].Value = objPharComm.PharmacyName ?? (object)DBNull.Value;
sqlParameter[2] = new SqlParameter(DBQueries.sqlPrm_generalManager, System.Data.SqlDbType.VarChar);
sqlParameter[2].Value = objPharComm.GeneralManager ?? (object)DBNull.Value;
sqlParameter[3] = new SqlParameter(DBQueries.sqlPrm_address, System.Data.SqlDbType.VarChar);
sqlParameter[3].Value = objPharComm.Address ?? (object)DBNull.Value;
sqlParameter[4] = new SqlParameter(DBQueries.sqlPrm_hours, System.Data.SqlDbType.VarChar);
sqlParameter[4].Value = objPharComm.Hours ?? (object)DBNull.Value;
sqlParameter[5] = new SqlParameter(DBQueries.sqlPrm_phone_area_Code, System.Data.SqlDbType.VarChar);
sqlParameter[5].Value = objPharComm.phone_area_code ?? (object)DBNull.Value;
sqlParameter[6] = new SqlParameter(DBQueries.sqlPrm_phonePrefix, System.Data.SqlDbType.VarChar);
sqlParameter[6].Value = objPharComm.phone_prefix ?? (object)DBNull.Value;
sqlParameter[7] = new SqlParameter(DBQueries.sqlPrm_phone_suffix, System.Data.SqlDbType.VarChar);
sqlParameter[7].Value = objPharComm.phone_suffix ?? (object)DBNull.Value;
sqlParameter[8] = new SqlParameter(DBQueries.sqlPrm_fax_area_code, System.Data.SqlDbType.VarChar);
sqlParameter[8].Value = objPharComm.fax_area_code ?? (object)DBNull.Value;
sqlParameter[9] = new SqlParameter(DBQueries.sqlPrm_fax_prefix, System.Data.SqlDbType.VarChar);
sqlParameter[9].Value = objPharComm.fax_prefix ?? (object)DBNull.Value;
sqlParameter[10] = new SqlParameter(DBQueries.sqlPrm_fax_suffix, System.Data.SqlDbType.VarChar);
sqlParameter[10].Value = objPharComm.fax_suffix ?? (object)DBNull.Value;
sqlParameter[11] = new SqlParameter(DBQueries.sqlPrm_ActiveFlag.ToString(), System.Data.SqlDbType.Bit);
sqlParameter[11].Value = objPharComm.ActiveFlag == true ? 1 : 0;
sqlParameter[12] = new SqlParameter(DBQueries.sqlPrm_Iteration.ToString(), System.Data.SqlDbType.Int);
sqlParameter[12].Value = objPharComm.Iteration;
sqlParameter[13] = new SqlParameter(DBQueries.sqlPrm_NCPDPID, System.Data.SqlDbType.VarChar);
sqlParameter[13].Value = objPharComm.NCPDPID ?? (object)DBNull.Value;
sqlParameter[14] = new SqlParameter(DBQueries.sqlPrm_NPI, System.Data.SqlDbType.VarChar);
sqlParameter[14].Value = objPharComm.NPI ?? (object)DBNull.Value;
sqlParameter[15] = new SqlParameter(DBQueries.sqlPrm_PharmacyEmail, System.Data.SqlDbType.VarChar);
sqlParameter[15].Value = objPharComm.PharmacyEmail ?? (object)DBNull.Value;
sqlParameter[16] = new SqlParameter(DBQueries.sqlPrm_CensusEmail, System.Data.SqlDbType.VarChar);
sqlParameter[16].Value = objPharComm.CensusEmail ?? (object)DBNull.Value;
sqlParameter[17] = new SqlParameter(DBQueries.sqlPrm_State, System.Data.SqlDbType.VarChar);
sqlParameter[17].Value = objPharComm.State ?? (object)DBNull.Value;
sqlParameter[18] = new SqlParameter(DBQueries.sqlprm_UseFoilBack, System.Data.SqlDbType.VarChar);
sqlParameter[18].Value = objPharComm.UseOnlyFoilback ?? (object)DBNull.Value;
sqlParameter[19] = new SqlParameter(DBQueries.sqlPrm_SubsidiaryPharmacy, System.Data.SqlDbType.VarChar);
sqlParameter[19].Value = objPharComm.SubsidiaryPharmacy ?? (object)DBNull.Value;
//sqlParameter[20] = new SqlParameter(DBQueries.sqlPrm_SubsidiaryPharmacy, System.Data.SqlDbType.VarChar);
//sqlParameter[20].Value = loginId ?? (object)DBNull.Value;
result = ExecuteSP("PharmericaCommon", query, sqlParameter);
}
catch (Exception ex)
{
return("Please try after some time, If it repeats please reach support team.");
}
return(result);
}
