public void Update()
{
txtRate.Text = "0";
FollowUPMaster FollowUP = new FollowUPMaster();
FollowUP.Description = Convert.ToString(txtDescription.Text);
FollowUP.Rate = Convert.ToDouble(txtRate.Text);
FollowUP.DepartmentId = cmbDeparment.SelectedValue.ToString();
FollowUP.FollowUpItemName = txtName.Text;
var subItems = listOfSubItem.Items;
FollowUP.ID = Convert.ToInt16(txtID.Text);
FollowUP.SubItems = new List <FollowUpSubItem>();
for (int i = 0; i < subItems.Count; i++)
{
FollowUpSubItem item = new FollowUpSubItem();
item.ItemId = Convert.ToInt32(txtID.Text); item.Id = subItems[i].SubItems[1].Text;
item.SubItemName = subItems[i].SubItems[2].Text;
FollowUP.SubItems.Add(item);
}
MessageModel messageModel = new FollowUpManager().UpdateService(FollowUP);
MessageBox.Show(messageModel.MessageBody, messageModel.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
SetNew();
}
public int UpdateService(FollowUPMaster followUp)
{
int count = 0;
Command = new SqlCommand("Update dbo.tblFollowUp set FollowUpItemName=@FollowUpItemName,Description=@Description,DepartmentID=@DepartmentID,Rate=@Rate where ID='" + followUp.ID + "'", Connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue("@FollowUpItemName", followUp.FollowUpItemName);
Command.Parameters.AddWithValue("@Description", followUp.Description);
Command.Parameters.AddWithValue("@DepartmentID", "");
Command.Parameters.AddWithValue("@Rate", followUp.Rate);
count = Command.ExecuteNonQuery();
Command = new SqlCommand("Delete tblFollowSubItems where ItemID ='" + followUp.ID + "'", Connection);
Command.CommandType = CommandType.Text;
count = Command.ExecuteNonQuery();
foreach (FollowUpSubItem subItem in followUp.SubItems)
{
Command = new SqlCommand("INSERT INTO dbo.tblFollowSubItems (ItemID,SubItemName,Id)"
+ "VALUES(@ItemID,@SubItemName,@Id)", Connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue("@ItemID", followUp.ID);
Command.Parameters.AddWithValue("@SubItemName", subItem.SubItemName);
Command.Parameters.AddWithValue("@Id", subItem.Id);
count = Command.ExecuteNonQuery();
}
return(count);
}
public int SaveFollowUPSetup(FollowUPMaster followUp)
{
int count = 0;
Command = new SqlCommand("INSERT INTO dbo.tblFollowUp (FollowUpItemName,Description,DepartmentID,Rate, ID)"
+ "VALUES(@FollowUpItemName,@Description,@DepartmentID,@Rate,@ID)", Connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue("@FollowUpItemName", followUp.FollowUpItemName);
Command.Parameters.AddWithValue("@Description", followUp.Description);
Command.Parameters.AddWithValue("@DepartmentID", "");
Command.Parameters.AddWithValue("@Rate", followUp.Rate);
Command.Parameters.AddWithValue("@ID", followUp.ID);
count = Command.ExecuteNonQuery();
foreach (FollowUpSubItem subItem in followUp.SubItems)
{
Command = new SqlCommand("INSERT INTO dbo.tblFollowSubItems (ItemID,SubItemName,Id)"
+ "VALUES(@ItemID,@SubItemName, @Id)", Connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue("@ItemID", followUp.ID);
Command.Parameters.AddWithValue("@SubItemName", subItem.SubItemName);
Command.Parameters.AddWithValue("@Id", subItem.Id);
count = Command.ExecuteNonQuery();
}
return(count);
}
public MessageModel UpdateService(FollowUPMaster FollowUP)
{
int saveService = new FollowUPGateway().UpdateService(FollowUP);
if (saveService > 0)
{
messageModel.MessageBody = "FollowUP Item Update successfully!";
messageModel.MessageTitle = "Successfull";
}
return(messageModel);
}
public List <FollowUPMaster> GetALLFollowUpWithSubItemsByDepartment(string Department, string Master)
{
List <FollowUPMaster> ListOfList = new List <FollowUPMaster>();
DataTable master = new FollowUPGateway().LoadDepartmetnwiseFollowUp(Department);
try
{
//.AsEnumerable().Where(a => Convert.ToInt16(a["ItemID"]) != 0).CopyToDataTable();
foreach (DataRow dataRow in master.Rows)
{
DataTable detials = new FollowUPGateway().LoadDepartmetnwiseSubFollowUp(Department, dataRow["ItemID"].ToString());
FollowUPMaster followup = new FollowUPMaster();
followup.SubItems = new List <FollowUpSubItem>();
var id = dataRow["ItemID"];
followup.ID = Convert.ToInt16(id);
followup.FollowUpItemName = dataRow["FollowUpItemName"].ToString();
//followup.DepartmentName = dataRow["DepartmentName"].ToString();
foreach (DataRow row in detials.Rows)
{
if (Convert.ToInt16(row["ItemID"]) == followup.ID)
{
followup.SubItems.Add(new FollowUpSubItem()
{
ItemId = followup.ID,
Id = row["SubId"].ToString(),
SubItemName = row["SubItemName"].ToString()
});
}
}
ListOfList.Add(followup);
}
}
catch (Exception ex)
{
string messag = ex.Message;
}
return(ListOfList.ToList());
}
private void btnSave_Click(object sender, EventArgs e)
{
List <FollowUPMaster> List = new List <FollowUPMaster>();
foreach (int row in gridView1.GetSelectedRows())
{
FollowUPMaster master = new FollowUPMaster();
master.SubItems = new List <FollowUpSubItem>();
var followupItem = gridView1.GetRowCellValue(row, "ID");
master.ID = Convert.ToInt16(followupItem.ToString());
master.DepartmentId = cmbDept.SelectedValue.ToString();
bool wasExpanded = gridView1.GetMasterRowExpanded(row);
if (!wasExpanded)
{
gridView1.ExpandMasterRow(row);
}
GridView detail = gridView1.GetDetailView(row, 0) as GridView;
if (detail != null)
{
foreach (int child in detail.GetSelectedRows())
{
var subItem = detail.GetRowCellValue(child, "Id");
master.SubItems.Add(new FollowUpSubItem
{
ItemId = Convert.ToInt16(followupItem),
Id = subItem.ToString()
});
}
}
List.Add(master);
}
string msage = new FollowUpManager().SaveFollowUpSheet(List);
MessageBox.Show(msage);
}
