public static int Insert_Complaint_Participant(int cmpgenid, int cmpid, string parttype, int partid, string roleid, int modifyby, int createby, string modifydate, string createdate)
{
using (ComplaintsDataContext cd = new ComplaintsDataContext())
{
TbL_Complaints_Participant cp;
if (cmpgenid == 0)
{
cp = new TbL_Complaints_Participant();
}
else
{
cp = cd.TbL_Complaints_Participants.Where(c => c.Cmp_Paticipant_ID == cmpgenid).SingleOrDefault();
}
cp.Cmp_Paticipant_ID = cmpgenid;
cp.Complaint_ID = cmpid;
cp.Participant_Type = parttype;
cp.Participant_ID = partid;
cp.Role_ID = roleid;
cp.modifiedBy = modifyby;
cp.modifiedDate = Convert.ToDateTime(modifydate);
cp.Create_User = createby;
cp.Create_Date = Convert.ToDateTime(createdate);
if (cmpgenid == 0)
{
cd.TbL_Complaints_Participants.InsertOnSubmit(cp);
}
cd.SubmitChanges();
return(cp.Cmp_Paticipant_ID);
}
}
public static int Complaint_Participant_InsertValues(TbL_Complaints_Participant participant, int flag)
{
int?i = 0;
using (ComplaintsDataContext dbInsert = new ComplaintsDataContext())
{
dbInsert.USP_Complaints_PaticipantDetailsIUD(flag, participant.Cmp_Paticipant_ID, participant.Complaint_ID, participant.Participant_Type, participant.Participant_ID,
participant.Role_ID, participant.IsExpected, participant.modifiedBy, participant.modifiedDate, participant.Name, participant.Address, participant.City, participant.State, ref i);
dbInsert.SubmitChanges();
return(i.Value);
}
}
