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