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); }