public SubContractor Insert(SubContractor objSubContractor)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
var result = new SubContractor();
IDbTransaction trn = connection.BeginTransaction();
string sql = @"INSERT INTO SubContractor(SubRefNo,SubName,ContactPerson,Designation,OfficeNo,MobileNo,Email,
Address1,Address2,Address3,Address4,CreatedBy,CreatedDate,OrganizationId)
VALUES(@SubRefNo,@SubName,@ContactPerson,@Designation,@OfficeNo,@MobileNo,@Email,@Address1,
@Address2,@Address3,@Address4,@CreatedBy,@CreatedDate,@OrganizationId);
SELECT CAST(SCOPE_IDENTITY() as int)";
try
{
int internalid = DatabaseCommonRepository.GetInternalIDFromDatabase(connection, trn, typeof(SubContractor).Name, "0", 1);
objSubContractor.SubRefNo = internalid.ToString();
int id = connection.Query <int>(sql, objSubContractor, trn).Single();
objSubContractor.SubContractorId = id;
InsertLoginHistory(dataConnection, objSubContractor.CreatedBy, "Create", "Subcontractor", id.ToString(), "0");
trn.Commit();
}
catch (Exception ex)
{
trn.Rollback();
objSubContractor.SubContractorId = 0;
objSubContractor.SubRefNo = null;
}
return(objSubContractor);
}
}
public string UpdateSubContractor(SubContractor model)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
IDbTransaction txn = connection.BeginTransaction();
try
{
string query = @"Update SubContractor Set SubRefNo=@SubRefNo,SubName=@SubName,ContactPerson=@ContactPerson,
Designation=@Designation,OfficeNo=@OfficeNo,MobileNo=@MobileNo,Email=@Email,Address1=@Address1,
Address2=@Address2,Address3=@Address3,Address4=@Address4,
CreatedBy=@CreatedBy,CreatedDate=@CreatedDate,OrganizationId=@OrganizationId
OUTPUT INSERTED.SubContractorId WHERE SubContractorId=@SubContractorId";
string ref_no = connection.Query <string>(query, model, txn).First();
InsertLoginHistory(dataConnection, model.CreatedBy, "Modify", "Subcontractor", ref_no.ToString(), "0");
txn.Commit();
return(ref_no);
}
catch (Exception ex)
{
txn.Rollback();
throw ex;
}
}
}
public void Put(long id, SubContractor data)
{
if (keyHandler.CheckApiKey(this.Request))
{
mapper.UpdateSubContractor(id, data);
}
}
public ResponseMessage CreateVendor(AddVendor vendor)
{
try {
if (_context.SubContractor.Where(x => x.Name == vendor.Name && x.IsDelete == false).Count() > 0)
{
throw new ValueNotFoundException("Vendor Name already exist.");
}
ResponseMessage responseMessage = new ResponseMessage();
SubContractor sc = _mapper.Map <SubContractor> (vendor);
sc.CreatedAt = DateTime.Now;
sc.CreatedBy = 1; //TODO
_context.SubContractor.Add(sc);
_context.SaveChanges();
//Add the sub contractor service type
if (vendor.VendorServiceTypeDetails.Any())
{
foreach (var item in vendor.VendorServiceTypeDetails)
{
SubContractorServiceType subContractorServiceType = new SubContractorServiceType();
subContractorServiceType.SubcontId = vendor.Id;
subContractorServiceType.ServicetypeId = item.ServiceTypeId;
_context.SubContractorServiceType.Add(subContractorServiceType);
}
}
responseMessage.Message = "Vendor created sucessfully";
return(responseMessage);
} catch (Exception ex) {
throw ex;
}
}
public List <SubContractor> SearchByType(int id)
{
using (var conn = Connection)
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT sc.Id AS SubId, sc.SubContractorBusinessName, sc.SubContractorImageUrl
FROM SubContractor sc
LEFT JOIN SubContractorJobType jt ON jt.SubContractorId = sc.Id
LEFT JOIN SubContractorType st ON jt.SubContractorTypeId = st.Id
WHERE st.Id = @id
";
DbUtilities.AddParameter(cmd, "@id", id);
var reader = cmd.ExecuteReader();
var subsOfType = new List <SubContractor>();
while (reader.Read())
{
var sub = new SubContractor()
{
Id = DbUtilities.GetInt(reader, "SubId"),
SubcontractorBusinessName = DbUtilities.GetString(reader, "SubContractorBusinessName"),
SubContractorImageLocation = DbUtilities.GetString(reader, "SubContractorImageUrl")
};
subsOfType.Add(sub);
}
reader.Close();
return(subsOfType);
}
}
}
public SubContractor Get(int id)
{
using (var db = DBConnection.GetConnection())
{
return(SubContractor.GetById <SubContractor>(db, id));
}
}
public bool Delete(SubContractor c)
{
using (var db = DBConnection.GetConnection())
{
return(SubContractor.Delete <SubContractor>(db, c));
}
}
public SubContractor Get(long ID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@SubContractorID", ID)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_SubContractor_By_ID", paramList);
SubContractor obj = new SubContractor();
obj.SubAddress = Convert.ToString(dt.Rows[0]["SubAddress"]);
obj.SubCode = Convert.ToString(dt.Rows[0]["SubCode"]);
obj.SubContactPerson = Convert.ToString(dt.Rows[0]["SubContactPerson"]);
obj.SubContractorID = Convert.ToInt64(dt.Rows[0]["SubContractorID"]);
obj.SubEmail = Convert.ToString(dt.Rows[0]["SubEmail"]);
obj.SubFax = Convert.ToString(dt.Rows[0]["SubFax"]);
obj.SubMobile = Convert.ToString(dt.Rows[0]["SubMobile"]);
obj.SubName = Convert.ToString(dt.Rows[0]["SubName"]);
obj.SubPhone = Convert.ToString(dt.Rows[0]["SubPhone"]);
obj.SubStatus = Convert.ToBoolean(dt.Rows[0]["SubStatus"]);
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public bool Post([FromBody] SubContractor c)
{
using (var db = DBConnection.GetConnection())
{
return(SubContractor.Persist <SubContractor>(db, c));
}
}
public HttpResponseMessage InsertSubContractor(SubContractor subContractor)
{
subContractor.Id = Guid.NewGuid();
var result = _subContractorService.InsertSubContractor(subContractor);
return(toJson(null, OperatingState.Success, result ? "添加成功" : "添加失败"));
}
public IEnumerable <SubContractor> Get()
{
using (var db = DBConnection.GetConnection())
{
return(SubContractor.GetAll <SubContractor>(db));
}
}
public ActionResult Create(SubContractor model)
{
model.CreatedBy = UserID.ToString();
model.CreatedDate = System.DateTime.Now;
model.OrganizationId = OrganizationId;
var repo = new SubContractorRepository();
bool isexists = repo.IsFieldExists(repo.ConnectionString(), "SubContractor", "SubName", model.SubName, null, null);
if (!isexists)
{
var result = new SubContractorRepository().Insert(model);
if (result.SubContractorId > 0)
{
TempData["Success"] = "Added Successfully!";
TempData["SubRefNo"] = result.SubRefNo;
return(RedirectToAction("Create"));
}
else
{
TempData["error"] = "Oops!!..Something Went Wrong!!";
TempData["SubRefNo"] = null;
return(View("Create", model));
}
}
else
{
TempData["error"] = "This Name Alredy Exists!!";
TempData["SubRefNo"] = null;
return(View("Create", model));
}
}
public void Post(SubContractor data)
{
if (keyHandler.CheckApiKey(this.Request))
{
mapper.CreateSubContractor(data);
}
}
public ActionResult Create(SubContractorFormViewModel viewModel)
{
if (!ModelState.IsValid)
{
return(View("SubContractorForm", viewModel));
}
var contractor = new SubContractor
{
SubcontractorId = Guid.NewGuid(),
AdministratorId = User.Identity.GetUserId(),
Region = viewModel.Region,
AffiliateRegion = viewModel.AffiliateRegion,
OrgName = viewModel.OrgName,
Director = viewModel.Director,
City = viewModel.City,
State = viewModel.State,
County = viewModel.County,
ZipCode = viewModel.ZipCode,
EIN = viewModel.EIN,
Address1 = viewModel.Address1,
PoBox = viewModel.PoBox,
Active = viewModel.Active,
SubmittedDate = DateTime.Now
};
db.SubContractors.Add(contractor);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public SubContractor GetById(int id)
{
using (var conn = Connection)
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT Id as SubId,
UserProfileId,
SubContractorBusinessName,
SubContractorImageUrl
FROM SubContractor
WHERE Id = @id
";
DbUtilities.AddParameter(cmd, "@id", id);
var reader = cmd.ExecuteReader();
SubContractor subContractor = null;
if (reader.Read())
{
subContractor = DbModelBuilder.BuildSubContractorModel(reader);
}
reader.Close();
return(subContractor);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (objSubContractor == null)
{
objSubContractor = new SubContractor();
}
objSubContractor.SubAddress = txtAddress.Text;
objSubContractor.SubCode = txtCode.Text;
objSubContractor.SubContactPerson = txtContactPerson.Text;
objSubContractor.SubEmail = txtEmail.Text;
objSubContractor.SubFax = txtFax.Text;
objSubContractor.SubMobile = txtMobile.Text;
objSubContractor.SubName = txtName.Text;
objSubContractor.SubPhone = txtPhone.Text;
objSubContractor.SubStatus = true;
long ID = objSubContractor_DL.Add(objSubContractor);
if (ID > 0)
{
MessageBox.Show(this, "Successfuly Saved", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Warning);
bindSub.DataSource = objSubContractor_DL.GetView();
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show(this, "Error occured while saving", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void gvSubContractors_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex >= 0)
{
long ID = Convert.ToInt64(gvSubContractors.Rows[e.RowIndex].Cells["ColID"].Value);
objSubContractor = objSubContractor_DL.Get(ID);
if (objSubContractor != null)
{
txtPhone.Text = objSubContractor.SubPhone;
txtName.Text = objSubContractor.SubName;
txtMobile.Text = objSubContractor.SubMobile;
txtFax.Text = objSubContractor.SubFax;
txtEmail.Text = objSubContractor.SubEmail;
txtContactPerson.Text = objSubContractor.SubContactPerson;
txtCode.Text = objSubContractor.SubCode;
txtAddress.Text = objSubContractor.SubAddress;
lblID.Text = objSubContractor.SubContractorID.ToString();
btnDelete.Enabled = true;
}
}
}
catch (Exception)
{
MessageBox.Show(this, "Error occured while loading Sub Contractor details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public ActionResult Create()
{
ViewBag.Title = "Create";
SubContractor SubContractor = new SubContractor();
SubContractor.SubRefNo = new SubContractorRepository().GetRefNo(SubContractor);
return(View(SubContractor));
}
public ActionResult DeleteConfirmed(int id)
{
SubContractor subContractor = db.SubContractors.Find(id);
db.SubContractors.Remove(subContractor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public List <SubContractor> UpdateSubContractorDetailsAsync(SubContractor sc, List <SubContractorSkillSetMapping> scSkillSets)
{
if (myconn.State != ConnectionState.Open)
{
myconn.Open();
}
SqlTransaction tran = myconn.BeginTransaction();
sc.createdDate = DateTime.Now;
sc.modifiedDate = DateTime.Now;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "SP_SubContractorInsertUpdate";
sqlCmd.Parameters.Add(new SqlParameter("@mode", "U"));
sqlCmd.Parameters.Add(new SqlParameter("@Id", sc.Id));
sqlCmd.Parameters.Add(new SqlParameter("@subconName", sc.subconName));
sqlCmd.Parameters.Add(new SqlParameter("@email", sc.email));
sqlCmd.Parameters.Add(new SqlParameter("@address", sc.address));
sqlCmd.Parameters.Add(new SqlParameter("@phoneNumber", sc.phoneNumber));
sqlCmd.Parameters.Add(new SqlParameter("@statusId", sc.statusId));
sqlCmd.Parameters.Add(new SqlParameter("@createdDate", sc.createdDate));
sqlCmd.Parameters.Add(new SqlParameter("@modifiedDate", sc.modifiedDate));
sqlCmd.Parameters.Add(new SqlParameter("@userId", sc.userId));
try
{
sqlCmd.Connection = myconn;
sqlCmd.Transaction = tran;
sqlCmd.ExecuteNonQuery();
if (scSkillSets != null)
{
foreach (SubContractorSkillSetMapping item in scSkillSets)
{
UpdateSubContractorSkillSetsDetailsAsync(item, sc.Id, tran);
}
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
gs.LogData(ex);
throw ex;
}
finally
{
if (myconn.State != ConnectionState.Closed)
{
myconn.Close();
}
}
return(GetSubContractorDetailsAsync(0, 'I'));
}
public HttpResponseMessage Insert([FromBody] SubContractor sc)
{
_SubContractorRepo.InsertSubContractorDetailsAsync(sc, sc.skillSelect);
var message = Request.CreateResponse(HttpStatusCode.Created, sc);
message.Headers.Location = new Uri(Request.RequestUri + sc.Id.ToString());
return(message);
}
public ActionResult Update(long id)
{
if (HttpContext.User.Identity.IsAuthenticated)
{
SubContractor sc = mapper.GetSubContractor(id);
return(View(sc));
}
return(RedirectToAction("LoginPage", "Connection"));
}
public IActionResult NewSubcontractor(SubContractor subContractor)
{
var currentUser = GetCurrentUserProfile();
subContractor.UserProfileId = currentUser.Id;
_subcontractorRepository.AddSubcontractor(subContractor);
return(Ok(CreatedAtAction("Get", new { id = subContractor.Id }, subContractor)));
}
/// <summary>
/// Insert the SubContractor
/// </summary>
/// <param name="subContractor"></param>
/// <returns></returns>
public bool InsertSubContractor(SubContractor subContractor)
{
if (subContractor == null)
{
throw new ArgumentNullException("subContractor is null");
}
bool result = _subContractorRepository.Insert(subContractor);
return(result);
}
/// <summary>
/// Updates the SubContractor
/// </summary>
/// <param name="subContractor"></param>
/// <returns></returns>
public bool UpdateSubContractor(SubContractor subContractor)
{
if (subContractor == null)
{
throw new ArgumentNullException("subContractor is null");
}
bool result = _subContractorRepository.SingleUpdate(subContractor);
return(result);
}
public ActionResult Edit([Bind(Include = "SubContractorID,LegacySubContractorCodeCCSP,LegacySubContractorCodeWWC,LegacySubContractorCodeCRCCP,SubContractorName,Address,CityBinID,StateBinID,ZipCode,ContactName,Phone,CountyBinID,Active,DateUpdated,UpdatedBy,DigitalMamIndicator,DigitalTechCode")] SubContractor subContractor)
{
if (ModelState.IsValid)
{
db.Entry(subContractor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(subContractor));
}
/// <summary>
/// Builds an instance of a SubContractor from a Sql Data Reader object
/// </summary>
/// <param name="reader"></param>
/// <returns>Instance of a <strong>SubContractor</strong></returns>
public static SubContractor BuildSubContractorModel(SqlDataReader reader)
{
var subcontractor = new SubContractor()
{
Id = DbUtilities.GetInt(reader, "SubId"),
UserProfileId = DbUtilities.GetInt(reader, "UserProfileId"),
SubcontractorBusinessName = DbUtilities.GetString(reader, "SubContractorBusinessName"),
SubContractorImageLocation = DbUtilities.GetString(reader, "SubContractorImageUrl"),
};
return(subcontractor);
}
public async Task <IActionResult> Update([FromBody] SubContractor subcontractor)
{
try
{
_context.Entry(subcontractor).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
return(Ok(subcontractor));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
public async Task <IActionResult> Create([FromBody] SubContractor subcontractor)
{
try
{
_context.SubContractor.Add(subcontractor);
_context.SaveChanges();
return(Ok(subcontractor));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
private void Clear()
{
txtPhone.Text = "";
txtName.Text = "";
txtMobile.Text = "";
txtFax.Text = "";
txtEmail.Text = "";
txtContactPerson.Text = "";
txtCode.Text = "";
txtAddress.Text = "";
objSubContractor = null;
lblID.Text = "[Auto]";
btnDelete.Enabled = false;
}
