//SUPPORT BUTTON---SUPPORT BUTTON---SUPPORT BUTTON---SUPPORT BUTTON---SUPPORT BUTTON
private void btnSaveSupport_Click(object sender, EventArgs e)
{
if (IsValidData())
{
VBRAsiaCusModel c = FillModel();
List <VBRAsiaCusModel> lc = VBRAsia_CustomersDA.GetVBRAsiaCustomer(Config.VBR4000Connection, c.Customer_No);
if (lc.Count > 0)
{
if (IsSupportValidData())
{
SupportDetailsModel m = SupportFillModel();
int i = SupportDetailsDA.UpdateSupportDetail(Config.VBR4000Connection, m);
i = SupportDetailsDA.InsertSupportDetails(Config.VBR4000Connection, m);
if (i == 1)
{
MessageBox.Show("Saved");
lc = VBRAsia_CustomersDA.GetVBRAsiaCustomer(Config.VBR4000Connection, m.CutomerNo);
if (lc.Count > 0)
{
FillForm(lc[0]);
}
}
}
}
else
{
MessageBox.Show("Please save the customer");
}
}
}
//SUPPORT DETAILS FillModel
private SupportDetailsModel SupportFillModel()
{
SupportDetailsModel m = new SupportDetailsModel();
m.CutomerNo = txtCustomer_No.Text.Trim();
m.ContactNo = txtTelephone1.Text.Trim();
m.Name = txtNamee.Text.Trim();
m.ShopName = txtShopNameS.Text.Trim();
m.SupportBy = cbSupportByS.Text.Trim();
m.SupportDetail = txtSupportDetailS.Text.Trim();
m.Suggestions = txtSuggestionsS.Text.Trim();
m.Notes = txtNotesS.Text.Trim();
m.SupportDate = dtpSupportDateS.Value;
return(m);
}
private void dgSupportDetails_CellClick(object sender, DataGridViewCellEventArgs e)
{
int rowIndex = e.RowIndex;
if (rowIndex >= 0)
{
string SupportDetailsId = dgSupportDetails["Id", rowIndex].Value.ToString();
int Id = Convert.ToInt32(SupportDetailsId);
SupportDetailsModel m = new SupportDetailsModel();
for (int i = 0; i < supportDetailsList.Count; i++)
{
if (Id == supportDetailsList[i].Id)
{
m = supportDetailsList[i];
}
}
txtSupportDetail.Text = m.SupportDetail;
txtSuggestions.Text = m.Suggestions;
txtNotes.Text = m.Notes;
}
}
public static List <SupportDetailsModel> GetSupportDetail(string Connection, string CutomerNo)
{
List <SupportDetailsModel> lm = new List <SupportDetailsModel>();
string sql = "";
#region SQL
sql += "SELECT [Id],[Customer_No],[Name],[ContactNo],[ShopName] ";
sql += ",[SupportBy],[SupportDetail],[Suggestions],[Notes] ";
sql += ",[SupportDate] FROM SupportDetails WHERE [Customer_No]=@CutomerNo ";
sql += "order by SupportDate";
#endregion SQL
using (SqlConnection conn = new SqlConnection(Connection))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@CutomerNo";
param.Value = CutomerNo;
param.DbType = DbType.String;
param.Size = 20;
command.Parameters.Add(param);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
SupportDetailsModel m = new SupportDetailsModel();
#region Fill Model
for (int i = 0; i < reader.FieldCount; i++)
{
if (i == 0)
{
try { m.Id = reader.GetInt32(i); }
catch { }
}
else if (i == 1)
{
try { m.CutomerNo = reader.GetString(i); }
catch { }
}
else if (i == 2)
{
try { m.Name = reader.GetString(i); }
catch { }
}
else if (i == 3)
{
try { m.ContactNo = reader.GetString(i); }
catch { }
}
else if (i == 4)
{
try { m.ShopName = reader.GetString(i); }
catch { }
}
else if (i == 5)
{
try { m.SupportBy = reader.GetString(i); }
catch { }
}
else if (i == 6)
{
try { m.SupportDetail = reader.GetString(i); }
catch { }
}
else if (i == 7)
{
try { m.Suggestions = reader.GetString(i); }
catch { }
}
else if (i == 8)
{
try { m.Notes = reader.GetString(i); }
catch { }
}
else if (i == 9)
{
try { m.SupportDate = reader.GetDateTime(i); }
catch { }
}
else if (i == 10)
{
try { m.Id = reader.GetInt32(i); }
catch { }
}
}
#endregion Fill Model
lm.Add(m);
}
}
}
}
return(lm);
}
public static int InsertSupportDetails(string Connection, SupportDetailsModel m)
{
int affectedRows = 0;
string sql = "";
#region SQL
sql += "INSERT INTO [SupportDetails] ";
sql += "([Customer_No],[Name],[ContactNo],[ShopName],[SupportBy], ";
sql += "[SupportDetail],[Suggestions],[Notes],[SupportDate]) ";
sql += "VALUES(@CutomerNo, @Name, @ContactNo,@ShopName, @SupportBy, ";
sql += "@SupportDetail,@Suggestions, @Notes, @SupportDate) ";
#endregion SQL
using (SqlConnection conn = new SqlConnection(Connection))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
#region Params
#region Line 1
//@CutomerNo, @Name, @ContactNo,@ShopName, @SupportBy
#region @CutomerNo
SqlParameter param = new SqlParameter();
param.ParameterName = "@CutomerNo";
param.Value = m.CutomerNo;
param.DbType = DbType.String;
param.Size = 20;
command.Parameters.Add(param);
#endregion @Customer_No
#region @Name
param = new SqlParameter();
param.ParameterName = "@Name";
param.Value = m.Name;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Name
#region @ContactNo
param = new SqlParameter();
param.ParameterName = "@ContactNo";
param.Value = m.ContactNo;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @ContactNo
#region @ShopName
param = new SqlParameter();
param.ParameterName = "@ShopName";
param.Value = m.ShopName;
param.DbType = DbType.String;
param.Size = 100;
command.Parameters.Add(param);
#endregion @ShopName
#region @SupportBy
param = new SqlParameter();
param.ParameterName = "@SupportBy";
param.Value = m.SupportBy;
param.DbType = DbType.String;
param.Size = 100;
command.Parameters.Add(param);
#endregion @SupportBy
#endregion Line 1
#region Line 2
//@SupportDetail,@Suggestions, @Notes, @SupportDate
#region @SupportDetail
param = new SqlParameter();
param.ParameterName = "@SupportDetail";
param.Value = m.SupportDetail;
param.DbType = DbType.String;
param.Size = 200;
command.Parameters.Add(param);
#endregion @SupportDetail
#region @Suggestions
param = new SqlParameter();
param.ParameterName = "@Suggestions";
param.Value = m.Suggestions;
param.DbType = DbType.String;
param.Size = 200;
command.Parameters.Add(param);
#endregion @Suggestions
#region @Notes
param = new SqlParameter();
param.ParameterName = "@Notes";
param.Value = m.Notes;
param.DbType = DbType.String;
param.Size = 200;
command.Parameters.Add(param);
#endregion @Notes
#region @SupportDate
param = new SqlParameter();
param.ParameterName = "@SupportDate";
param.Value = m.SupportDate;
param.DbType = DbType.DateTime;
//param.Size = 200;
command.Parameters.Add(param);
#endregion @SupportDate
#endregion Line 2
#endregion Params
affectedRows = command.ExecuteNonQuery();
}
}
return(affectedRows);
}
public static int UpdateSupportDetail(string Connection, SupportDetailsModel m)
{
int affectedRows = 0;
string sql = "";
#region SQL
sql += "UPDATE SupportDetails ";
sql += "SET [Customer_No] = @CutomerNo,[Name] = @Name ";
sql += ",[ContactNo] = @ContactNo,[ShopName] = @ShopName,[SupportBy] = @SupportBy ";
sql += ",[SupportDetail] = @SupportDetail,[Suggestions] = @Suggestions ";
sql += ",[Notes] = @Notes,[SupportDate] = @SupportDate ";
sql += " WHERE [Id]=@id";
#endregion SQL
using (SqlConnection conn = new SqlConnection(Connection))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
#region Params
#region LINE1
//[CutomerNo] = @CutomerNo,[Name] = @Name
#region @CutomerNo
SqlParameter param = new SqlParameter();
param = new SqlParameter();
param.ParameterName = "@CutomerNo";
param.Value = m.CutomerNo;
param.DbType = DbType.String;
param.Size = 20;
command.Parameters.Add(param);
#endregion @CutomerNo
#region @Name
param = new SqlParameter();
param.ParameterName = "@Name";
param.Value = m.Name;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Name
#endregion LINE1
#region LINE2
//[ContactNo] = @ContactNo,[ShopName] = @ShopName,[SupportBy] = @SupportBy
#region @ContactNo
param = new SqlParameter();
param.ParameterName = "@ContactNo";
param.Value = m.ContactNo;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @ContactNo
#region @ShopName
param = new SqlParameter();
param.ParameterName = "@ShopName";
param.Value = m.ShopName;
param.DbType = DbType.String;
param.Size = 100;
command.Parameters.Add(param);
#endregion @ShopName
#region @SupportBy
param = new SqlParameter();
param.ParameterName = "@SupportBy";
param.Value = m.SupportBy;
param.DbType = DbType.String;
param.Size = 100;
command.Parameters.Add(param);
#endregion @SupportBy
#endregion LINE2
#region LINE3
//[SupportDetail] = @SupportDetail,[Suggestions] = @Suggestions
#region @SupportDetail
param = new SqlParameter();
param.ParameterName = "@SupportDetail";
param.Value = m.SupportDetail;
param.DbType = DbType.String;
param.Size = 200;
command.Parameters.Add(param);
#endregion @SupportDetail
#region @Suggestions
param = new SqlParameter();
param.ParameterName = "@Suggestions";
param.Value = m.Suggestions;
param.DbType = DbType.String;
param.Size = 200;
command.Parameters.Add(param);
#endregion @Suggestions
#endregion LINE3
#region LINE4
//[Notes] = @Notes,[SupportDate] = @SupportDate,[Id]=@id
#region @Notes
param = new SqlParameter();
param.ParameterName = "@Notes";
param.Value = m.Notes;
param.DbType = DbType.String;
param.Size = 200;
command.Parameters.Add(param);
#endregion @Notes
#region @SupportDate
param = new SqlParameter();
param.ParameterName = "@SupportDate";
param.Value = m.SupportDate;
param.DbType = DbType.DateTime;
//param.Size = 200;
command.Parameters.Add(param);
#endregion @SupportDate
#region @id
param = new SqlParameter();
param.ParameterName = "@id";
param.Value = m.Id;
param.DbType = DbType.Int32;
//param.Size = 200;
command.Parameters.Add(param);
#endregion @id
#endregion LINE4
#endregion Params
affectedRows = command.ExecuteNonQuery();
}
}
return(affectedRows);
}
