public int SaveCompany(CompanyMasterEntities company) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AccountantDBConnectionString"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("usp_InsertCompanyMaster_Web", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CompanyName", company.CompanyName); cmd.Parameters.AddWithValue("@CompanyAddress", company.CompanyAddress); cmd.Parameters.AddWithValue("@YearId", company.YearId); cmd.Parameters.AddWithValue("@CompanyCode", company.CompanyCode); cmd.Parameters.AddWithValue("@isMaster", company.isMaster); if (string.IsNullOrEmpty(company.ParentCompanyID.ToString()) || (company.ParentCompanyID == 0)) { cmd.Parameters.AddWithValue("@ParentCompanyId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ParentCompanyId", company.ParentCompanyID); } cmd.Parameters.Add(new SqlParameter("@CompanyId", SqlDbType.Int)); cmd.Parameters[6].Direction = ParameterDirection.Output; int recordsAffected = cmd.ExecuteNonQuery(); con.Close(); return(recordsAffected); }
public List <CompanyMasterEntities> GetAllMasterCompanies(int yearId) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AccountantDBConnectionString"].ConnectionString); con.Open(); List <CompanyMasterEntities> listMasterCompnay = new List <CompanyMasterEntities>(); CompanyMasterEntities company = new CompanyMasterEntities(); SqlCommand cmd = new SqlCommand("usp_GetAllMasterCompanies", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@YearId", yearId); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) { listMasterCompnay.Add(new CompanyMasterEntities { CompanyId = Convert.ToInt32(dr["CompanyId"].ToString()), CompanyName = Convert.ToString(dr["CompanyName"]), CompanyCode = Convert.ToString(dr["CompanyCode"]), }); } con.Close(); return(listMasterCompnay); }
public JsonResult UpdateCompanyMaster(CompanyMasterEntities company) { CompanyMasterBL companybl = new CompanyMasterBL(); int recordAffected = companybl.UpdateCompany(company); return(Json(recordAffected, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveCompanyMaster(CompanyMasterEntities company) { CompanyMasterBL companyMasterBL = new CompanyMasterBL(); //int recordsaffected = companyMasterBL.SaveCompany(company); //return Json(recordsaffected, JsonRequestBehavior.AllowGet); return(Json(companyMasterBL.SaveCompany(company), JsonRequestBehavior.AllowGet)); }
public int UpdateCompany(CompanyMasterEntities companyentity) { CompanyMasterDAL companyDAL = new CompanyMasterDAL(); try { return(companyDAL.UpdateCompany(companyentity)); } catch (Exception ex) { throw ex; } finally { companyDAL = null; } }
public HttpResponseMessage update(CompanyMasterEntities obj) { response = null; var objcon = Regex.Replace(obj.objheader.name, @"\s+", ""); try { var Message = ""; if (obj != null) { var Dupcon = db.Companylists.FirstOrDefault(x => (x.name.Replace(" ", "") == objcon) && (obj.objheader.Id != x.Id)); if (Dupcon == null) { var CityTable = CompanyMasterRepository.GetCompanyMasterById(obj.objheader.Id); // CityTable.cid = obj.objheader.cid; CityTable.code = obj.objheader.code; CityTable.name = obj.objheader.name; CityTable.status = obj.objheader.status; CompanyMasterRepository.UpdateCompanyMaster(CityTable); CompanyMasterRepository.SaveCompanyMasterMaster(); Message = "1"; response = Request.CreateResponse <string>(HttpStatusCode.OK, Message); } else { Message = "2"; response = Request.CreateResponse <string>(HttpStatusCode.OK, Message); } } } catch (Exception ex) { //_objErrorHelper.APIMethodName = "Update"; //_objErrorHelper.APIControllerName = "CityAPIController"; //ErrorLogger.LogError(ex, _objErrorHelper); response = Request.CreateResponse <string>(HttpStatusCode.NotFound, "Failed"); } return(response); }
public int UpdateCompany(CompanyMasterEntities company) { string constr = ConfigurationManager.ConnectionStrings["AccountantDBConnectionString"].ConnectionString; SqlConnection myConn = new SqlConnection(constr);// connection string myConn.Open(); SqlCommand cmd = new SqlCommand("usp_UpdateCompanyMaster", myConn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CompanyId", company.CompanyId); cmd.Parameters.AddWithValue("@CompanyName", company.CompanyName); cmd.Parameters.AddWithValue("@CompanyAddress", company.CompanyAddress); cmd.Parameters.AddWithValue("@YearId", company.YearId); cmd.Parameters.AddWithValue("@CompanyCode", company.CompanyCode); int recordsAffected = cmd.ExecuteNonQuery(); myConn.Close(); return(recordsAffected); }
public CompanyMasterEntities GetCompanyById(int companyId) { string constring = ConfigurationManager.ConnectionStrings["AccountantDBConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(constring); con.Open(); SqlCommand cmd = new SqlCommand("usp_SelectCompanyMaster", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CompanyId", companyId); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); CompanyMasterEntities company = new CompanyMasterEntities(); con.Close(); company.CompanyId = Convert.ToInt32(ds.Tables[0].Rows[0]["CompnayId"].ToString()); company.CompanyName = ds.Tables[0].Rows[0]["CompanyName"].ToString(); return(company); }
public int SaveCompany(CompanyMasterEntities company) { CompanyMasterDAL comp = new CompanyMasterDAL(); return(comp.SaveCompany(company)); }