protected void performMove(String CID) { SqlConnection LAconn = new SqlConnection(); var conn = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; LAconn.ConnectionString = conn; var comDal = new CompanyDAL(conn); var OwnerId = comDal.CheckCompanyOwnerByID(CID); if (!string.IsNullOrEmpty(OwnerId)) { String strSQLInsertStmt = "UPDATE dbo.Companies SET OwnershipAdminID = @OwnershipAdminID, OwnershipPeriod = NULL WHERE CompanyID =@CompanyID"; SqlCommand LAcmd = new SqlCommand(strSQLInsertStmt, LAconn); LAcmd.Parameters.AddWithValue("@OwnershipAdminID", OwnerId); LAcmd.Parameters.AddWithValue("@CompanyID", CID); try { LAconn.Open(); LAcmd.ExecuteNonQuery(); LAconn.Close(); } catch (Exception ex) { Console.Write(ex.Message.ToString()); } } }
protected void SaveButton_Click(object sender, EventArgs e) { var hourAcco = "7"; if (Session["sorList"] != null) { var comList = Session["sorList"] as List <CompanyView>; foreach (var item in comList) { var comdal = new CompanyDAL(CONNSTRING); var resComId = comdal.CheckCompanyOwnerByID(item.CompanyID); if (string.IsNullOrEmpty(resComId)) { comdal.CreateOwnerCompanyId(item.CompanyID, item.OwnershipAdminID.ToString()); } PerformMove(item.CompanyID, hourAcco); } } }