Beispiel #1
0
        // POST api/CRMCusContact?tblCuscontact
        public void Post([FromBody] tblCusContact cc)
        {
            using (var ctx = new CRMModel())
            {
                var cuscon = ctx.Set <tblCusContact>();
                cuscon.Add(new tblCusContact
                {
                    CusId         = cc.CusId,
                    ContactId     = cc.ContactId,
                    ContactName   = cc.ContactName,
                    ContactPhoneH = cc.ContactPhoneH,
                    ContactPhoneO = cc.ContactPhoneO,
                    ContactPhoneM = cc.ContactPhoneM,
                    ContactFax    = cc.ContactFax,
                    ContactEmail  = cc.ContactEmail,
                    EmId          = cc.EmId,
                    AddPerson     = cc.AddPerson,
                    Department    = cc.Department
                });

                ctx.SaveChanges();
            }
        }
Beispiel #2
0
        // PUT api/CRMCusContact?CusId,ContactId,tblCuscontact
        public void Put(string CusId, string ContactId, [FromBody] tblCusContact cc)
        {
            using (var ctx = new CRMModel())
            {
                // Update Statement
                var update = ctx.tblCusContacts.Where(ci => ci.CusId == CusId).FirstOrDefault();
                if (update != null)
                {
                    update.CusId         = cc.CusId;
                    update.ContactId     = cc.ContactId;
                    update.ContactName   = cc.ContactName;
                    update.ContactPhoneH = cc.ContactPhoneH;
                    update.ContactPhoneO = cc.ContactPhoneO;
                    update.ContactPhoneM = cc.ContactPhoneM;
                    update.ContactFax    = cc.ContactFax;
                    update.ContactEmail  = cc.ContactEmail;
                    update.EmId          = cc.EmId;
                    update.AddPerson     = cc.AddPerson;
                    update.Department    = cc.Department;
                }

                ctx.SaveChanges();
            }
        }